Crosstab and Transpose

[mgcarrenard]

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.

[derekbelyea · Accepted solution]

This will do it.

[LordNeilLord]

Hi @mgcarrenard,

Crosstab  Transpose is the tool for you :) (thanks @derekbelyea)

[mgcarrenard]

Thanks guys! This totally worked.

Cheers