Forum Discussion
Solved
Splitting Column data into columns under Specific Text/Headers
Hello, I need help splitting column text data separated by semi-colons into columns. The challenge is that the cells' data are randomly stored in the cells i.e 1st data in cell A1 may be the 2nd in ...
Hi fuulhouse ,
Based on your description, you could do some steps in Power Query editor.
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler, there is always a fix.
fuulhouse Post some sample data as text in a table and somebody might try. I am thinking, add an Index column. Split out your column by semi-colon. Unpivot. Sort by Index and then secondary sort by the Value column. Something, something something...
