Forum Discussion
Solved
Table format change using power query
Can anyone please guide me about a table alignment conversion using power query? Kindly see the excel file attached.
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 it transforms like magic. Thank you.
How the month can transform into the required column as a repeating item?
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.