Rearrange of data

[Anjankumar2021]

Hi Team, @binuacs 

could someone advise on the below.

Input
Date	Account	Volume
11/04/2025	Savings	66
[Null]	Total	66
14/04/2025	Savings	8
14/04/2025	Current	102
[Null]	Total	110
15/04/2025	Savings	23
15/04/2025	Current	90
[Null]	Total	113
16/04/2025	Savings	5
16/04/2025	Current	128
[Null]	Total	133
17/04/2025	Savings	9
17/04/2025	Current	135
[Null]	Total	144
18/04/2025	Savings	20
18/04/2025	Current	54
[Null]	Total	74
Required
Output
Date	Savings	Current	Total
11/04/2025	66		66
14/04/2025	8	102	110
15/04/2025	23	90	113
16/04/2025	5	128	133
17/04/2025	9	135	144
18/04/2025	20	54	74

[Qiu]

@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.

[davidskaife]

Hi @Anjankumar2021 

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