Rearrange of data

Question

Hi Team, @binu_acs

could someone advise on the below.

Input   DateAccountVolume 11/04/2025Savings66 [Null]Total66 14/04/2025Savings8 14/04/2025Current102 [Null]Total110 15/04/2025Savings23 15/04/2025Current90 [Null]Total113 16/04/2025Savings5 16/04/2025Current128 [Null]Total133 17/04/2025Savings9 17/04/2025Current135 [Null]Total144 18/04/2025Savings20 18/04/2025Current54 [Null]Total74         Required    Output           DateSavingsCurrentTotal11/04/202566 6614/04/2025810211015/04/2025239011316/04/2025512813317/04/2025913514418/04/2025205474

davidskaife · Answer

Hi @Anjankumar2021

Here you go, use a Multi-Row tool to fill in the NULL dates, then simply Cross Tab the data

Transform.yxmd

Qiu · Answer

@Anjankumar2021 
If my understanding is correct, we can then fill the null date cell with its upper row value then use a Cross Tab tool to format the data.

0501-Anjankumar2021.yxmd