Create table from columns

[montesfj]

Hello there I need to create a table or convert columns into a table.  I have two column one with ID and the other with names separated with semicolon.  The top rows contain the data as is now and I want to create a table like the one below.  Any help will be greatly appreciated.  Thank you!

[Anonymous · Accepted solution]

@montesfj 
Follow the steps in power query:

1. Split the SharedWith column with semilcolon

2. Select the 3 columns and unpivot

3. Remove the attribute column

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

try (to adapt) this