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
