Rows to Column

[Rayyyyy]

Hello, can someone help me how I can transpose these data in the rows into columns.

the new format should look like this. Thanks in advance

[gawa · Accepted solution]

hi @Rayyyyy 

 Cross tab would help. Before cross tab, put a group number by Multi-row formula(if detecting "Value Date", then regards it as a next group). Refer to attached workflow for your ready refrence.

[Rayyyyy]

Hi @gawa,

Thanks you so much. It helps. :)

[binuacs · Accepted solution]

@Rayyyyy Another method with tile tool