Forum Discussion
anupambit1797
Feb 09, 2024Iron Contributor
Power Query , split multiple columns in one Go
Dear Experts, Greetings! I have an issue where we have multiple columns to be split with the same delimiter say "=", then why need to select each column every time and perform th...
- Feb 10, 2024
anupambit1797 From earlier posts I conclude that you aren't totally unfamiliar with PQ. Without being mean or rude, I believe you should be able to this yourself. Just do what I suggested above.
Step 1) connect to the txt file
Step 2) select all 10 columns and merge them with "=" as the separator
Step 3) split the resulting single column using "=" as delimiter.
This will turn the original 10 column table into one with 20 columns.
Riny_van_Eekelen
Feb 10, 2024Platinum Contributor
anupambit1797 From earlier posts I conclude that you aren't totally unfamiliar with PQ. Without being mean or rude, I believe you should be able to this yourself. Just do what I suggested above.
Step 1) connect to the txt file
Step 2) select all 10 columns and merge them with "=" as the separator
Step 3) split the resulting single column using "=" as delimiter.
This will turn the original 10 column table into one with 20 columns.
anupambit1797
Feb 10, 2024Iron Contributor
Thanks Riny_van_Eekelen for this trick, yes it worked 🙂 last step , what step(single or at max 2 steps) shall I use to move the 1st cell of each header as below and simultaneously deleting those rows?
So, that final outcome shall be like this ( below):-
Thanks in Advance,
Br,
Anupam
- Riny_van_EekelenFeb 11, 2024Platinum Contributor
anupambit1797 The easiest way would be to just rename the relevant columns on-by-one (that's step 1) and then use 'Choose Columns' to select only the columns you renamed (that's step 2).