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!
@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.
@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.
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
