Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Feb 09, 2024

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...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    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.

Resources