Split Delimited to Rows!
May 22, 2017 - by Bill Jelen
![Split Delimited to Rows! Split Delimited to Rows!](/img/excel-tips/2017/05/split-delimited-to-rows.jpg)
Dustin has a column with 1 to 16 values separated by ;
Watch Video
- Dustin has a column with 1 to 16 values separated by ;
- There are 8 columns total in the data
- He wants the ; separated to rows
- The May 2017 update to Power Query adds the ability to split a column to Rows
Download File
Download the sample file here: Podcast2097.xlsm
Title Photo: Hermann / Pixabay