Forum Discussion
Text delimit into upgrouped raw data
I have two columns, Group ID and Name. The name column is a string of multiple names with a semicolon in between each name. I would text delimited the two columns and then transpose as a vertical list. How would I repeat the Group ID for each name in the same group when transposing as a vertical list? Thank you for any assistance.
1 Reply
1. While active in your range, Data | Get & Transform | From Table.
2. Select the Name column in Power Query. Transform | Split column on semicolon at each instance
3. Select Group ID column | Transform | Unpivot other columns
4. Remove Attribute column
5. Home | Close and Load
6. Enjoy
