Query related Excel

[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..??

Here is a attached file

[#2]

Hi @Excel 

See attached file

[#3]

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

[#4 · Accepted solution]

@Excel 

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

[#5]

Thank you very much sir.

[#6]

@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

[#7]

Now i clear understand
Thank you very much sir.