Help with Splitting up Data

[Dstein]

I have a set of data that looks like this:

F1	F2	F3	F4
	Activity Date	Net Trade	Net Cash
Account 1
Wednesday	05/11/2022	-74,638.62	0
Thursday	05/12/2022	17,243.91	-74,638.62
Friday	05/13/2022	67,247.07	17,243.91
Monday	05/16/2022	-70,770.88	67,247.07
Tuesday	05/17/2022	-22,116.47	-70,770.88
Wednesday	05/18/2022	0	-22,116.47
Wednesday	06/01/2022	-722,700.00	0
Thursday	06/02/2022	0	-722,700.00
Account 2
Wednesday	05/11/2022	-2,444,003.88	0
Thursday	05/12/2022	467,746.48	-2,444,003.88
Friday	05/13/2022	1,872,374.73	467,746.48
Monday	05/16/2022	-1,043,716.01	1,872,374.73
Tuesday	05/17/2022	181,732.97	-1,043,716.01
Wednesday	05/18/2022	0	181,732.97
Wednesday	06/01/2022	-322,700.00	0
Thursday	06/02/2022	0	-322,700.00

The amount of rows is not constant, some days it can show 8 per account, other days 5 rows. Need to figure out a way to dynamically split into two tables like so:

Account 1	Activity Date	Net Trade	Net Cash
Wednesday	05/11/2022	-74,638.62	0
Thursday	05/12/2022	17,243.91	-74,638.62
Friday	05/13/2022	67,247.07	17,243.91
Monday	05/16/2022	-70,770.88	67,247.07
Tuesday	05/17/2022	-22,116.47	-70,770.88
Wednesday	05/18/2022	0	-22,116.47
Wednesday	06/01/2022	-722,700.00	0
Thursday	06/02/2022	0	-722,700.00

Account 2	Activity Date	Net Trade	Net Cash
Wednesday	05/11/2022	-2,444,003.88	0
Thursday	05/12/2022	467,746.48	-2,444,003.88
Friday	05/13/2022	1,872,374.73	467,746.48
Monday	05/16/2022	-1,043,716.01	1,872,374.73
Tuesday	05/17/2022	181,732.97	-1,043,716.01
Wednesday	05/18/2022	0	181,732.97
Wednesday	06/01/2022	-322,700.00	0
Thursday	06/02/2022	0	-322,700.00

[IraWatt]

Hey @Dstein 

To achieve this I think you want to do this:

Essentially the multi row formula figures out which row belongs to which account. Please ask if you have any questions.

HTH,

Ira

[grazitti_sapna]

Hi @Dstein , this can also be achieved using a Reporting tool.

Thanks!

[brianfia]

Maybe not the most efficient, but here is my take.