How to transform two way table in excel into simple long table

[Das_Chenji]

Hello all , 

Please help me how to transform the following table 

Project Number	Qtr1	Qtr2	Qtr3
11516	25000	32000	12000
11517	16000	14000	2000
11435	89000	42000	34000

to the following format

Project Number	Qtr	Amount
11516	Qtr1	25000
11516	Qtr2	32000
11516	Qtr3	12000
11517	Qtr1	16000
11517	Qtr2	14000
11517	Qtr3	2000
11435	Qtr1	89000
11517	Qtr2	42000
11517	Qtr3	34000

[#2 · Accepted solution]

@Das_Chenji 

The easiest is with Power Query

- query the table, select Project Number column, Unpivot other columns, Rename headers, load back to sheet.

[#3]

Sergei, Many thanks, this solution worked perfectly fine.

[#4]

@Das_Chenji , you are welcome