How to Copy Values using Specific Conditions?

[crazybeauti_ful]

Hi,

In the sample below, I need to copy the values of *ABC in Header 2 & Amount IF Header 1 is equal to *DEF - how do I do that? I can't use multi-row because Header 0 can be random in terms of rows placing. Help please.

  Row            Header 0                 Header 1   Header 2    Amount

   12            Account 1                 1 ABC        1 ABC         111.11

   15            Account 1                 1 DEF

   20            Account 1                 1 DEF

   50            Account 1                 1 DEF

   51            Account 1                 1 GHI         1 GHI           222.22

   52            Account 2                 2 ABC        2 ABC          33.33

   55            Account 2                 2 DEF        

   100          Account 2                 2 DEF        

Thank you.

[danilang]

Hi @crazybeauti_ful 

Can you please provide an example of the output you're looking for?

Dan

[RolandSchubert · Accepted solution]

Hi @crazybeauti_ful ,

I would consider selecting the source rows to copy using a Filtier tool, joining these rows to the target rows using a Join tool and perform the copy using a formula. I've attached a sample workflow. What do you think?

Best,

Roland

[crazybeauti_ful]

hey, apologies for the late reply. super thank you for the solution. it solved my issue 🙂