Power Query: Split Multiple Columns into Rows All At Once

It’s easy to split columns in Power Query and split into rows. But here’s a situation where there’s data in 3 columns that will fly apart and get unmatched if we split one column without splitting the other 2 at the same time.

One solution would be to split the source data into 3 pieces, split the columns into rows, add index columns, then use outer joins to piece the data back together.

We’re not going to do that today!We’re going to use Power Query’s lists, and 2 functions:
Text.Split
Table.FromColumns

These are going to make for a smooth solution!

#SplitMultipleColumns
#PowerQuery
#Text.Split

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2