Hello,
I am trying to achieve the following:
Input -
Year | Month | Field_1 | Field_2 |
2018 | 01 | 15 | 16 |
2018 | 02 | 17 | 18 |
Output -
Year | Month | Field | Amount |
2018 | 01 | Field_1 | 15 |
2018 | 02 | Field_1 | 17 |
2018 | 01 | Field_2 | 16 |
2018 | 02 | Field_2 | 18 |
Could you guys help me out? I realize that it must be achievable through some combination of Transpose and Crosstab but I can't seem to figure it out.
Thanks in advance.
Solved! Go to Solution.
Thanks guys! This totally worked.
Cheers