Convert Rows to Column

[RichardAlt]

Hi All,

I'm having a problem converting rows to column using Cross Tab Tool,

This is my sample input,

Fund Code	Account	Amount
S2022	12345	123532.12
S2022	43564	324324.64
S2024	54343	452.23

I have 2 fund codes which are S2022 and S2024 (Note: Sometimes the fund codes are 3 or more.)

I already try to convert this using Cross Tab Tool.

This is my current output.

My desired output is this.

Thank you!

[Qiu · Accepted solution]

@RichardAlt 

This fully dynamic one should work 😁. 

[RichardAlt]

Thank you @Qiu 

The fund code must be in the same column.

[Qiu · Accepted solution]

@RichardAlt 

I am sorry about it and thank you for pointing out.

Here is the revised one.