Oct 12 2020 11:20 AM - edited Oct 12 2020 11:49 AM
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
Oct 12 2020 12:49 PM
Solutioneasiest 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
Oct 12 2020 02:40 PM
Thanks for your help!
I am using a power query.
-splitting columns by delimiter - done
- How to expand lists to rows?
Oct 12 2020 04:06 PM
@Sergei Baklan It worked perfectly!! thanks !!!
Oct 12 2020 12:49 PM
Solutioneasiest 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