Split Delimited to Rows!


May 22, 2017 - by

Split Delimited to Rows!

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