MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split Delimited to Rows!


May 22, 2017 - by Bill Jelen

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


Bill Jelen is the author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.