Split data into Rows by Delimeter By default, Power Query will treat the entire cell content as a single value and load it as a single record with one column and one row. To split the data, go to ...

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

Here's how to make your data more useful -- or even just more presentable -- using the Join and Split operators and the Split method.