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

Posted on: 06/29/2022

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

Recent Microsoft Teams articles

YouTube Video

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

Steps to get to the Power Query Editor

Click inside your data
Click the Data tab
Click From Table/Range in the Get & Transform Data group
Your data will be be created in a Table. Click Yes if you only have one header row.
The Power Query Editor opens.

**From Table/Range - Get & Transform Data**

Recent Excel articles

Removing Duplicates Using Power Query

We're going to take a look at removing duplicates using Power Query in Excel.

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Exploring the 4 percent rule through Microsoft Excel provides a hands-on approach to understanding how it might apply to your retirement planning.

Optimizing Microsoft Excel Files for Better Performance

Excel has a new feature called Check Performance. Check Performance will determine if your workbook is slow and optimize performance.

Excel Business Functions - Functions everyone should know - Excel Essentials Training

Did you know that there are over 500 Functions in Excel? In this short video, part of my Excel Essentials Training Course, we look at the seven business functions I use all the time, and these functions should be used by every Excel user.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.