Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/08/Combine-rows-in-single-cell.xlsx
In this video I demonstrate how to combine multiple rows into one cell in Excel, using Power Query.
This video tip will show you how to do the following:
- House data in an Excel table
- Use the Power Query Editor to group by and merge columns
- Fill down values within a column
- Use the Text.Combine function in the Power Query Editor
------------------------