Solved: Split Columns into Rows is NOT available using Pow...

DonBisset · ‎08-13-2021

Power Query Desktop has supported split a column by delimiter into rows for some time.. it is a very common requirement.

I have just started using Data Flows on the Power BI platform HOWEVER the split column feature does not have the option to split into columns. Is this feature not available - is there any other way to achieve this?

mahoneypat · ‎08-13-2021

You can add a custom column using the Text.Split([ColumnWithDelimitedValues], ",") (or whatever you delimiter is). That will create a List on each row, and then you can expand that column choosing "Expand to new rows".

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

DonBisset · ‎08-13-2021

Awesome thanks Pat..
Initially, I didn't think it had worked as the system function 'inserted rows' whereas your solution appended,
I'm good to go. Thanks Again

mahoneypat · ‎08-13-2021

You can add a custom column using the Text.Split([ColumnWithDelimitedValues], ",") (or whatever you delimiter is). That will create a List on each row, and then you can expand that column choosing "Expand to new rows".

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube