Excel Delimited Delight: Split Delimited to New Rows! - Episode 2097

*Mind Blown*

If I have 2 columns with comma value will I be able to split them into rows

does anybody know how to using this to create product and variant for store product in wix ?

Can someone figure out how to do this in excel version 2010 for around 2000 rows of data

Great tip and most useful.

omg...PQ is awesome

power query never ceases to amaze. awesome trick.

Love this : ) Power Query is sooooo amazing!!!

Amazing, Just amazing! !!

Very easy! Thanks!

Awesome