Convert Matrix Pivot Table Date to Simple Data Table in Excel - Part 1

If users copying data from PivotTable ot get data in matrix format, users unable to use PivotTable in MATRIX format data. Today, I want to share process How to Convert Matrix data in simple excel file.

First view the sample data in matrix format. If we need to create simple table, we need to follow copy paste manually and it is time consuming task. In excel, we can easily conver matrix data in simple table.

STEP -1
Please follow the sample data which I created



Step -2

Keep mouse pointer in any cell and press CTRL + T

Output as per below image




Step - 3
Please select POWER QUERY
After Excel 2010 version, Power Query are available in 2010, 2013, 2016 with Office 365. To download POWER QUERY, please visit the link :- https://www.microsoft.com/en-in/download/details.aspx?id=39379



Step - 4
Select POWER QUERY
Then select From Table as below image



Step-5
In POWER QUERY, data shows as follow




Step - 6
Selete the First Column "PRODUCT NAME"
Go to TRANSFORM menu
Choose option "UNPIVOT OTHER COLUMN" as follows



OUTPUT will be



You are finish to create simple data table from Matrix/PivotTable.

Tomorrow I will share PART - 2 on CONVERT COMPLEX MATRIX DATA INTO SIMPLE DATA TABLE IN EXCEL