Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
106
Views
Topic starter
Hello again,
I have a table with a column that contains several values in each cell.
I would like to split that column into separate columns (easy!) BUT with each value under its particular header - which I am struggling with.
I have attached an example file showing the input and the desired results.
Thanks in advance.
Robert
Posted : 13/07/2024 2:33 pm
I thought of a simple Power Query solution. Would that work for you? See attached.
Posted : 14/07/2024 3:23 am
Topic starter
Thank you, Riny.
Perfect!
And by adding an Index column at the beginning and then removing it at the end, I can keep the original order.
Many thanks
Posted : 14/07/2024 10:51 am
