Transforming Table Shapes: Group Rows and Merge Columns in Power Query

Learn how to reshape your tables in Power Query by grouping rows and merging columns to better organize and analyze your data. In this video, we'll demonstrate practical techniques for transforming table structures, including grouping rows based on specific criteria and merging columns for a more streamlined dataset. Whether you're consolidating data or preparing reports, these powerful transformations will enhance your data manipulation skills and improve your workflow. Follow along to master these essential Power Query techniques!

00:00 Define the problem
00:52 Solution 1 Unpivoting
01:20 Solution 1 Grouping
04:30 Solution 1 Adding a new column
05:47 Solution 2 Merging columns
06:47 Converting value types