Forum Discussion
Solved
Formatting help with Transpose
Hi everyone,
I am trying to split the Standard released column in such a way after the semicolon it should in the next row. Please see attached excel sheet
Input
Output
easiest way is with Power Query
- convert the source to table or name it as Range and query
- split first column texts to list with semicolon delimiters
- expand lists to rows
- load result to Excel sheet
4 Replies
easiest way is with Power Query
- convert the source to table or name it as Range and query
- split first column texts to list with semicolon delimiters
- expand lists to rows
- load result to Excel sheet
Thanks for your help!
I am using a power query.
-splitting columns by delimiter - done
- How to expand lists to rows?
SergeiBaklan It worked ..thanks
