Transpose
Does anyone knows how to transpose by more than 1 ID?
The report before transpose looks like :
Branch month product
1 Jan-07 HO 1000
Jan-07 AUTO 1005
Feb-07 HO 1100
Feb-07 AUTO 2000
2 Jan-07 HO 1000
Jan-07 AUTO 1005
Feb-07 HO 1100
Feb-07 AUTO 2000
And after transpose:
Jan-07 Feb-07
HO AUTO HO AUTO
Branch
1 1000 1005 1100 2000
2 1000 1005 1100