Data manipulation using Multi-row formula

Data_Alter

I have this data which I am trying to cleanse using multi-row but have not been able to

Few lines from the data 

Account	Number	Amount	Amount
200000	FA
Date	Journal number	Amount	Amount
03/02/2020	1	0	0
03/02/2020	2	0	0
Totals		0	0
Net difference
300000	Cash
Date	Journal number	Amount	Amount
29/02/2020	3	0	0
01/03/2020	4	0	0
02/03/2020	5	0	0
03/03/2020	6	0	0
15/03/2020	18	0	0
16/03/2020	19	0	0
17/03/2020	20	0	0
Totals		0	0
Net difference
400000	Liabilities
Date	Journal number	Amount	Amount
21/03/2020	24	0	0
21/03/2020	25	0	0
21/03/2020	26	0	0
21/03/2020	27	0	0

I want it to look like this. I am sure this is possible using multi-row

Account	Number	Amount	Amount	Account	Description
200000	FA
Date	Journal number	Amount	Amount
03/02/2020	1	0	0	200000	FA
03/02/2020	2	0	0	200000	FA
Totals		0	0
Net difference
300000	Cash
Date	Journal number	Amount	Amount
29/02/2020	3	0	0	300000	Cash
01/03/2020	4	0	0	300000	Cash
02/03/2020	5	0	0	300000	Cash
03/03/2020	6	0	0	300000	Cash
15/03/2020	18	0	0	300000	Cash
16/03/2020	19	0	0	300000	Cash
17/03/2020	20	0	0	300000	Cash
Totals		0	0
Net difference
400000	Liabilities
Date	Journal number	Amount	Amount
21/03/2020	24	0	0	400000	Liabilities
21/03/2020	25	0	0	400000	Liabilities
21/03/2020	26	0	0	400000	Liabilities
21/03/2020	27	0	0	400000	Liabilities

clmc9601

Hi @Data_Alter,

Yes, this can be accomplished with multi-row! 

Here you go. I hope it helps!

multi-row_takkarstar.yxmd