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...
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