Hi,
I know to split into rows based on one column, but cannot find a way to split based on more than one column, as the "Split Column" is grayed out when more than one column is selected.
I have attached a sample file that I want to split into rows based on column I & J.
Regards,
Ayal Telem.
Hi Ayal,
It's not clear what the end result is that you want, but I suggest you merge the columns first, then split.
Mynda
Dear Mynda,
Basically, column I & J each contains rows that corresponds to parallel row in the other column, e.g.: on row 4 "AEGIS" & "55504" should be on a row, and "GCube" & "WI194355001A5" on another. Data on all other columns should copied to both rows.
Merge will not work, as it takes the full content of cell in column I and paste the content of cell in column J at the end.
Regards,
Ayal Telem.
Similar to the problem solved in the thread in the link below:
https://www.myonlinetraininghub.com/excel-forum/power-query/handling-multi-value-cells
I've adapted the solution that was provided by @Velouria in the above link to your data set. See attached.
Hi Riny,
First, thanks for taking the time to help me - highly appreciated.
I looked at you solution, and I vaguely understand the solution.
As I'm starting my Power Query course here, I believe that by the end of it I will probably understand your solution better.
Thanks a lot,
Ayal Telem.
I'm confident that you'll get to grips to PQ soon. Good luck!
