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!
