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.
Solved! Go to 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
hey, apologies for the late reply. super thank you for the solution. it solved my issue 🙂