Query related Excel

Super Contributor

Hello Everyone, 

I have a data :

Annotation 2022-08-18 143111.png


How to convert the above table to the below table ?


It should come :

Annotation 2022-08-18 143439.png


Note - I am using Microsoft Office Home and Student 2019


Please help..??


Here is a attached file


6 Replies

Hi @Excel 


See attached file

Sir, Can you please explain step by step in Power Query ?

best response confirmed by Excel (Super Contributor)



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

Now i clear understand
Thank you very much sir.