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
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
SergeiBaklan It worked perfectly!! thanks !!!
