Multi row formula help needed

Question

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 code0ExemptVat rate0%Reference numberAccountDateNetVat100001ACCOUNT104/10/20225000100002ACCOUNT104/10/2022  Vat code1StandardVat rate20%Reference numberAccountDateNetVat100003ACCOUNT104/10/20221000200100004ACCOUNT104/10/202225050100005ACCOUNT104/10/202250001000

Thanks in advance!

JB

OllieClarke · Answer

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

taxcode.yxmd

JamesBarzda · Answer

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

binu_acs · Answer

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