How to get the data from other columns when one field is empty

[MadhavTR]

Input

reference	gstcode	accode	ABN
0987	P1	123
0987		456	2345

Expected output

reference	gstcode	accode	ABN
0987		456	2345

can you suggest how to achieve this?

[Luke_C]

Can you say more about the logic? It looks like you could just filter on empty gst code records to get your output. 

[MadhavTR]

this is my exact usecase

Input

Reference	gstcode	Amount	Description	ABN
123	P1	10	GST
123	P1	11	GST
123	P1	100	Amount
123	P1	110	Amount
123		-210		ABCD1234

Output

Reference	gstcode	Amount	Tax	ABN
123	P1	210	21	ABCD1234

1. I created a filter for keyword GST and summarizing it (using summarize tool  group by reference, gstcode and sum(amount)

2. Then creates another filter for !GST and summarizing it (using summarize tool  group by reference, gstcode and sum(amount)

3. Join these 2 data to get

Reference	gstcode	Amount	Tax
123	P1	210	21

4. But now when i create a filter on gstcode null and then try to multiple join, that time it is failing and now working

[Ken_Lam]

Would a Multi Row Formula beforehand to fill in the blank gstcode (taking the gstcode from the row above) suffice?

That would allow the join multiple to work.