Skip to main content
Microsoft Idea

Power BI

Needs Votes

Unpivot nested column groups

Vote (12) Share
Colin's profile image

Colin on 14 Mar 2017 09:03:53

It's common to find Excel data sources with merged cells as column headings and nested "sub-columns".

Please add built-in support for unpivoting nested column groups.

An example of a work-around:
https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/

The Tabealu Data Reshaper add-in for Excel can detect these column groupings automatically.
https://community.tableau.com/docs/DOC-10394