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:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2