Power Query: Split Column by Delimiter and Split into Rows

/in /by

So, you’ve got a bunch of data all in one cell. You need to not only get it out, but it needs to be in rows, stacked in a single column.

With this new Get & Transform (Power Query) feature it’s EASY!
Split Column by Delimiter into Rows

This video has 2 examples:
1. A plain example
2. A real world example

You’ll also see a left outer join … and a sword.

Download the file here:
http://datascopic.net/columns2rows
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2