How to split delimited into rows.
I tried using Power Query.
With Power Query I can do it only for 1 column.
If I select more than 1 column, the Split Column is disabled in the Power Query Editor.
Is there any other solution for splitting delimited into rows for more than one column?
This video offers three solutions.
Solution 1 is a formula such as =TEXTJOIN(“|”,,TEXTSPLIT(C2,”,”)&”-“&TEXTSPLIT(B2,”,”)) and then Power Query.
The 2nd solution is M code written by Suat Ozgur. Get that code from MrExcel:
https://www.mrexcel.com/board/threads/power-query-split-to-rows-for-2-similar-columns-2520.1219302/
The 3rd solution is two intermediate queries in Power Query and then a merge query.
Table of Contents
(0:00) How to Split to Rows
(0:11) TEXTSPLIT formula
(1:30) M solution
(2:44) 3-Query solution