Excel - Get and Transform Data | Unpivot Columns with Two Header Rows

Excel's Unpivot Columns, part of Power Query, is an awesome feature. It is the easier way to fix data that isn't in a tabular format. You want data in a tabular format so it can be sorted, filtered, and PivotTables created. In this video, we will look at data with one header row and then move on to data with two header rows, which is a big no-no in Excel.

We will use UnPivot Columns and use the Transpose feature in Power Query.

Chapters/Bookmarks
0:00 Intro
0:55 One Header Row
4:07 Two Header Rows
5:18 Transpose in Power Query
6:05 Use the First row as Header
7:25 Check data

#msexcel #powerquery #exceltraining #chrismenard #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[marykatambi]

Your videos have really been helpful to me. Please, do videos on SQL too. Keep up the good work, Chris.