
Power Query

October 7, 2021

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.

Power Query

October 7, 2021

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.


Trusted Members
Moderators
Power BI

January 31, 2022

Similar to the problem solved in the thread in the link below:
https://www.myonlinetraininghu.....alue-cells
I've adapted the solution that was provided by @Velouria in the above link to your data set. See attached.

Power Query

October 7, 2021

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.
