Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
I have the below set of data where I am trying to use the multirow tool to copy data from the order# to receivedcode based on criteria. Essentially if the order starts with IR then IR1 would be copied into the Receivedcode column. If order# starts with a numerical value (1234 etc), I would copy the data from the Code column. I have tried several approaches but none seem to work. Any assistance would be appreciated.