Forum Discussion
Solved
Query related Excel
Hello Everyone, I have a data : How to convert the above table to the below table ? It should come : Note - I am using Microsoft Office Home and Student 2019 Please help...
Sir, Can you please explain step by step in Power Query ?
Please
It's all done with the PQ User Interface:
- Go to Data tab > Queries & Connections (the Q&C pane opens)
- Double-click on query Table1
- Follow step by step in APPLIED STEPS
- Thank you very much sir.
Excel . Glad I could help. Couple of things:
- You marked as response something that won't help those who search
- You were already asked to used more meaningful Subjects (something reflecting the issue/your need) - here, queries are all Excel related
- I just updated my 1st reply with an easier query - Re-download the attachment please