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

Posted on:  06/29/2022
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. 

Power Query - Unpivot columns

Power Query - Unpivot columns

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
Power Query Editor

Power Query Editor

Steps to get to the Power Query Editor

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

 

From Table/Range - Get & Transform Data

From Table/Range - Get & Transform Data

Disney Event with Chris Menard in September 2022

Recent Excel articles

Calculated Items in an Excel PivotTable

Calculated Items in an Excel PivotTable

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How to use XLOOKUP function in Excel

How to use XLOOKUP function in Excel

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Excel file size out of control? Learn how to reduce Excel spreadsheet file size

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories