SOLVED

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 ?
Please

best response confirmed by Excel (Super Contributor)
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

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.