I need support joining data within my flow. In one sheet, I have a list of codes, and in the other sheet, I have a list of descriptions associated with each code. In the codes sheet, there are 3 columns, Code 1 Code 2 and Code 3. Sometimes there is only a code in code 1, sometimes in 1 and 2, and sometimes in 1,2, and 3. I need support with a flow that grabs the descriptions that are associated with each code and populates in a new sheet with all the data.
I want the output to be on the right, and have a "code 1 description" "code 2 description" "code 3 description"
Any tips?
