Transform row to column

[Anonymous]

Hi All

I am trying to transpose row to column

I got output correctly but curious to as is this right way?

Any other option ?

QV attached

[Gysbert_Wassenaar]

Well, you could change the field names:

T1:

CrossTable(Column, Month)

LOAD *  ...etc

Instead of a field named Value you would get a field named Month.

[Anonymous]

Hi Gysbert

Thanks for suggestion