SOLVED

Table format change using power query

%3CLINGO-SUB%20id%3D%22lingo-sub-2135156%22%20slang%3D%22en-US%22%3ETable%20format%20change%20using%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ECan%20any%20please%20guide%20me%20about%20a%20table%20alignment%20conversion%20using%20power%20query%3F%20Kindly%20see%20the%20excel%20file%20attached.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2135156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2135176%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20format%20change%20using%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966718%22%20target%3D%22_blank%22%3E%40shohan421%3C%2FA%3E%26nbsp%3BSelect%20the%20first%20three%20columns%20(Manufacturer%2C%20Type%20and%20Country)%2C%20right-click%20and%20choose%20%22Unpivot%20other%20columns%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2135192%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20format%20change%20using%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bit%20transforms%20like%20magic.%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20the%20month%20can%20transform%20into%20the%20required%20column%20as%20a%20repeating%20item%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2135197%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20format%20change%20using%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966718%22%20target%3D%22_blank%22%3E%40shohan421%3C%2FA%3E%26nbsp%3BDon't%20really%20know%20how%20that%20happened.%20See%20my%20version%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20I%20see%20now.%20You%20didn't%20use%20the%20first%20row%20as%20headers.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Can anyone please guide me about a table alignment conversion using power query? Kindly see the excel file attached.

9 Replies

@shohan421 Select the first three columns (Manufacturer, Type and Country), right-click and choose "Unpivot other columns".

@Riny_van_Eekelen it transforms like magic. Thank you. 

How the month can transform into the required column as a repeating item?

best response confirmed by shohan421 (Occasional Contributor)
Solution

@shohan421 Don't really know how that happened. See my version attached.

 

Edit: I see now. You didn't use the first row as headers.

@Riny_van_Eekelen Thank you. I am able to organize my data. It was 2000 row and now it becomes 100000 rows (as required). Again thank you very much. 

@shohan421 Well done! Glad I could help.

@Riny_van_Eekelen Can you please help me with another conversion? Please see the attached. Thank you. 

@shohan421 Always best to upload an Excel file, rather than a Word document. Anyhow, I replicated your "situation" and attach a file with the query in it.

 

Thank you. I will upload excel file from next request. A lot to learn.

@shohan421 No problem. But also better to open a new conversation, rather that continuing an old (already resolved) unrelated thread.