Convert Complex Matrix format data into Simple Table by UnPivot option - Part 2

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 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

Post a Comment


Contact Form


Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget