Horizontal to Vertical data by month

[Ibrarbutt]

I have more 1000 information as below

ID No	Student Name	March	April	May	June	July	Aug	Sept	Oct
25	Test 1	100	250	2552	255	2222	45211	222	22
454	test 2	500	55	222	66	33	44	88	0
55	test 4	150	444	547	44	444	11	445	444

I am looking for below tables as

ID	Student Name	Month	Amount
25	Test 1	March	100
25	Test 1	April	250
25	Test 1	May	2522

.
.
.
.
.


i HAVE BELOW DATA AS

 

[denzo36]

You can achieve this with Power Query - what version of Excel do you have?

 

[Ibrarbutt]

You can achieve this with Power Query - what version of Excel do you have?

Excel 2007

 

[denzo36]

Unfortunately, there is no way that I know of to achieve this in Excel 2007 with formulas.

Any one else have any suggestions?

 

[Ibrarbutt]

Which version of excel it can be? And how i will try to get version

 

[denzo36]

Power Query is available from Excel 2010 onwards, it's a free add-in for Excel 2010 and is part of Excel Data tab after that.

You would need to pay for a newer version of Excel through Microsoft