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 / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.