Forum Discussion
shohan421
Feb 15, 2021Copper Contributor
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.
- Feb 15, 2021
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
Feb 15, 2021Platinum Contributor
shohan421 Well done! Glad I could help.
shohan421
Feb 18, 2021Copper Contributor
Riny_van_Eekelen Can you please help me with another conversion? Please see the attached. Thank you.
- Riny_van_EekelenFeb 18, 2021Platinum Contributor
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.
- shohan421Feb 18, 2021Copper ContributorThank you. I will upload excel file from next request. A lot to learn. 🙂
- Riny_van_EekelenFeb 18, 2021Platinum Contributor
shohan421 No problem. But also better to open a new conversation, rather that continuing an old (already resolved) unrelated thread.