Feb 14 2021 10:42 PM - edited Feb 14 2021 10:48 PM
Can anyone please guide me about a table alignment conversion using power query? Kindly see the excel file attached.
Feb 14 2021 10:46 PM
@shohan421 Select the first three columns (Manufacturer, Type and Country), right-click and choose "Unpivot other columns".
Feb 14 2021 11:00 PM
@Riny_van_Eekelen it transforms like magic. Thank you.
How the month can transform into the required column as a repeating item?
Feb 14 2021 11:10 PM - edited Feb 14 2021 11:12 PM
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.
Feb 14 2021 11:36 PM
@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.
Feb 15 2021 12:32 AM
@shohan421 Well done! Glad I could help.
Feb 18 2021 03:28 AM
@Riny_van_Eekelen Can you please help me with another conversion? Please see the attached. Thank you.
Feb 18 2021 04:00 AM
@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.
Feb 18 2021 04:40 AM
Feb 18 2021 04:52 AM
@shohan421 No problem. But also better to open a new conversation, rather that continuing an old (already resolved) unrelated thread.
Feb 14 2021 11:10 PM - edited Feb 14 2021 11:12 PM
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.