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!
Solved! Go to Solution.
@justinirizarry22
Typical legacy data processing, hehe
@justinirizarry22 I see @Qiu provided the solution for the actual file. Below is the another solution for your example
Thank you!
Another great solution, thank you!
Glad to help and thank you for the accept mark.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |