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.
Please follow the sample data which I created
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
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