Transpose Data - -to a single row

[ll98]

Hi -- I'm trying to transpose the data -- but its creating multiple rows based  per GL Account --  Based on the Investor (ISCID ) - I would want to see all the GL Account listed in the same row but in its corresponding Columns.

Thanks 

[apathetichell · Accepted solution]

Hi again - Go into your cross tab tool and unclick "GL Account" and "Amount" under Group-by.

[Qiu · Accepted solution]

@ll98 
Just an illustration of @apathetichell advice and I also use the Dynamic Rename to fix the Field Names messed up by Cross Tab tool 😁

 

[ll98 · Accepted solution]

Thanks @apathetichell @Qiu