Has any idea how to convert this table layout into another?

%3CLINGO-SUB%20id%3D%22lingo-sub-2608011%22%20slang%3D%22en-US%22%3EHas%20any%20idea%20how%20to%20convert%20this%20table%20layout%20into%20another%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2608011%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20this%20data%20from%20pivot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nichanall_0-1628047533163.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300329i9F3BF7D42366DBC8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22nichanall_0-1628047533163.png%22%20alt%3D%22nichanall_0-1628047533163.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20guide%20how%20can%20I%20change%20it%20to%20something%20like%20the%20following%20example%20(without%20manual%20work)%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nichanall_1-1628047578036.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300330i02DE51006D228E0F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22nichanall_1-1628047578036.png%22%20alt%3D%22nichanall_1-1628047578036.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example%20pivot%20file%20in%20case%20anyone%20wants%20to%20try%20playing%20around.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ENichanal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2608011%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2608383%22%20slang%3D%22en-US%22%3ERe%3A%20Has%20any%20idea%20how%20to%20convert%20this%20table%20layout%20into%20another%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2608383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1119906%22%20target%3D%22_blank%22%3E%40nichanall%3C%2FA%3E%26nbsp%3BConsider%20using%20PowerQuery%20to%20unpivot%20the%20data.%20If%20you%20have%20used%20PQ%20before%2C%20you'll%20know%20how%20to%20do%20that.%20If%20you%20haven't%2C%20learn%20some%20basics%20first%20from%20the%20attached%20link.%20In%20there%2C%20chapter%2013%20clearly%20explains%20the%20process%20of%20unpivoting%20data.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I have this data from pivot.

 

nichanall_0-1628047533163.png

 

Can anyone guide how can I change it to something like the following example (without manual work)?

nichanall_1-1628047578036.png

 

I have attached an example pivot file in case anyone wants to try playing around.

 

Thank you very much.

 

Regards,

Nichanal

 

 

1 Reply

@nichanall Consider using PowerQuery to unpivot the data. If you have used PQ before, you'll know how to do that. If you haven't, learn some basics first from the attached link. In there, chapter 13 clearly explains the process of unpivoting data.

https://exceloffthegrid.com/power-query-introduction/