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
Solved! Go to Solution.
Hi again - Go into your cross tab tool and unclick "GL Account" and "Amount" under Group-by.
@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 😁
Thanks @apathetichell @Qiu