Power Query transformations can assist in splitting data into rows, based on various factors such as delimiter, text patterns, and data types.

Using Excel Power Query Combine Columns into Rows: Merge address data into a single column with line feed characters for better readability.

And many of the query options in Excel 2016’s data tab come from the Power Query add-in for Excel 2010 and 2013.

This month’s column shows how to clean and join data using Excel’s Power Query.