Aug 18 2022 02:05 AM - edited Aug 18 2022 02:06 AM
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..??
Here is a attached file
Aug 18 2022 02:19 AM - edited Aug 18 2022 04:18 AM
Aug 18 2022 02:26 AM - edited Aug 18 2022 03:11 AM
Sir, Can you please explain step by step in Power Query ?
Please
Aug 18 2022 03:45 AM
Solution
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
Aug 18 2022 04:23 AM
@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
Aug 18 2022 03:45 AM
Solution
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