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

Copilot for Excel: Transforming Complex Data with Advanced Delimiter Separation

Discover how Microsoft 365 Copilot revolutionizes Excel data management by automating complex tasks like delimiter separation. Explore the benefits and a step-by-step guide in our latest blog post.

Easily Combine Ranges with VSTACK and HSTACK in Excel

VSTACK and HSTACK are two great functions in Excel. We will use them to combine ranges.

Excel Focus Cell: Enhancing Active Cell Visibility and Navigation

Microsoft Excel has introduced an exciting new feature called Focus Cell, designed to improve the visibility of the active cell and enhance navigation within spreadsheets. This powerful tool highlights the current cell's row and column, making it easier to track your position in large datasets.

Excel 7 Easy Tips Everyone Should Know

Excel is a powerful tool that can significantly enhance productivity when used effectively. Here, we present seven time-saving Excel tips that will help you work more efficiently.

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite 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.