Log In
Register
Home
Power Query
October 7, 2021
Offline
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.
July 16, 2010
Offline
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
Power Query
October 7, 2021
Offline
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
Offline
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
Offline
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.
