Excel UnPivot option to convert matrix data into simple table

In last session, we discuss the process to convert Matrix Table Data into Simple Excel Table. For details, please find the link :- Convert Matrix Date in Simple table data

Today we will convert Matrix format data as follows


Please insert one blank row in top. Users need to create Unique field data for First Two Heading Rows as follows


Copy the Entire worksheet and paste it another sheet as TEXT
Place the PRODUCT NAME in A1 cell
Remove 2 and 3 number rows


Press CTRL+T


Select POWER QUERY FROM TABLE


Select the first column and choose UNPIVOT OTHER COLUMNS


Now need to Split B column data


Therefore our requirement is solved and we will process the data in excel.

Click on Closed and Apply

Excel Power Query will copy and paste data in new excel sheet.

Please find the video