Multi row formula help needed

[JamesBarzda]

Hi,

I'm looking to use the multi row formula to do the following to the below data:

- I have a row of data, before a bunch of transactions, that indicates which vat code they sit under

- I want to append the VAT code description (third row in) to each relevant row e.g. reference number 100001 and 100002 would have a new column (called tax code) containing 'Exempt'. 100003, 100004 and 100005 would then have 'Standard' in their column (and so on for difference Tax Codes)

- I can then filter on the new column to split out the different tax codes

Vat code	0	Exempt	Vat rate	0%
Reference number	Account	Date	Net	Vat
100001	ACCOUNT1	04/10/2022	500	0
100002	ACCOUNT1	04/10/2022
Vat code	1	Standard	Vat rate	20%
Reference number	Account	Date	Net	Vat
100003	ACCOUNT1	04/10/2022	1000	200
100004	ACCOUNT1	04/10/2022	250	50
100005	ACCOUNT1	04/10/2022	5000	1000

Thanks in advance!

JB

[binu_acs]

@JamesBarzda Can you upload your expected result in an excel file for a better understanding of the requirement?

[JamesBarzda]

Hi @binu_acs,

Sure, this would be the desired result; addition of the tax code flag column (see below). Whenever it finds specified words (exempt, standard etc), it stops appending the previous value and appends the new

[OllieClarke]

Hi @JamesBarzda 

How's this:

so the Tax Code Flag is Standard for the header line, and then uses the value in column C for all subsequent lines (restarting whenever column A is Vat code).

Ollie