Moving data in column to rows with off Excel file

[justinirizarry22]

Hi community, I am working with a data set that is not structured in the best way and I'm struggling with how to move values stored in rows to columns.

For example, the data set has revenue numbers for project for each month like this:

	January
Project Name	Beginning	Revenue	Adjustment	Net	Ending
A	1000000	100000	25000	125000	875000
B
C

And I want the data transformed to be like this:

Project Name	Type	Month	Amount
A	Beginning	January	1000000
A	Revenue	January	100000
A	Adjustment	January	25000
A	Net	January	125000
A	Ending	January	875000

The actual file (sample) I am working with is below. I have tried transposing the data and summarizing but I'm totally stuck after that!

[Qiu · Accepted solution]

@justinirizarry22 
Typical legacy data processing, hehe

[binuacs]

@justinirizarry22 I see @Qiu  provided the solution for the actual file. Below is the another solution for your example

Spoiler

[justinirizarry22]

Thank you!

[justinirizarry22]

Another great solution, thank you!

[Qiu]

@justinirizarry22 

Glad to help and thank you for the accept mark.