Unpivot ANY Nested Table to PivotTable

Unpivot ANY Nested Table to PivotTable

Gil Raviv Gil Raviv

Gil Raviv

Creator of BI Pixie, Data & AI leader, author, Microsoft MVP alumni

Published Oct 18, 2015
+ Follow

Here is my fourth post that show you how to transform any nested table in Excel into PivotTable using the Unpivot transformation through the Get & Transform section of the Data tab in Excel 2016, or through the Power Query Add-in that is available on Excel 2010 and 2013.

Follow me on twitter (@gilra) to get more cool stuff on Excel & Power BI.

To view or add a comment, sign in

More articles by Gil Raviv

  • Learn how to build your own COVID-19 dashboard
    Mar 18, 2020

    Learn how to build your own COVID-19 dashboard

    Check out this tutorial to build your own queries in Power BI and gain a reliable and daily refreshable COVID-19…

    6 Comments
  • Are you riding the wave of Power BI?
    Jan 20, 2020

    Are you riding the wave of Power BI?

    Check out my new blog post. This time we discuss the momentum of Power BI and what you can do about it (or fail to).

    6 Comments
  • "Power BI is a Data Visualization Tool"
    Dec 22, 2019

    "Power BI is a Data Visualization Tool"

    Following my last article on DataChant and touched by your reactions, I decided to create this poster. If you think…

    10 Comments
  • Bad Practices in Power BI - The Pie Chart Prologue
    Oct 17, 2019

    Bad Practices in Power BI - The Pie Chart Prologue

    DataChant is launching a new series that will focus on bad practices in Power BI. Instead of sharing with you tips &…

    20 Comments
  • Unpivot Pairs of Columns in Power BI
    Oct 11, 2019

    Unpivot Pairs of Columns in Power BI

    DataChant's guest, Sandeep Pawar shares his story in this new blog post. Learn how to unpivot pairs of columns in two…

  • My 3rd Power BI Template App is available on Azure AppSource
    Sep 12, 2019

    My 3rd Power BI Template App is available on Azure AppSource

    Are you familiar with the new Power BI Template Apps, do you still work with old content packs? Are you a publisher of…

    1 Comment
  • My 2nd Power BI Template App is available on Azure AppSource
    Mar 25, 2019

    My 2nd Power BI Template App is available on Azure AppSource

    You can now apply a basic analyze of any 4 facebook pages in Power BI using a new templae app that I released on…

  • The Impact of Power Query - Survey Results
    Dec 17, 2018

    The Impact of Power Query - Survey Results

    Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power…

    3 Comments
  • Collect, Combine, and Transform Data
    Nov 9, 2018

    Collect, Combine, and Transform Data

    My book is finally out. You can find it on Amazon, and on Pearson's InformIT (great price if you want the bundle: Book…

    16 Comments
  • My Book is Now in Production
    Jun 7, 2018

    My Book is Now in Production

    I am celebrating my birthday today, and wanted to share with you a quick update about my book. Check out my latest blog…

    19 Comments
See all articles

Insights from the community

Others also viewed

Explore topics