Power Query: Split Column by Delimiter and Split into Rows
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
#PowerQuerySplitIntoRows #SplitRowsByDelimiter #SplitDataIntoRows
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2