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 ...

Power Query’s Columns From Examples feature can do more than transpose values – it can also combine multiple values into a single cell.