How to consolidate information in an array that is unique into one column?
I'm sure I'm overthinking this but I can figure out in my brain how to get the intended result
I have a flow that takes results form a Form I created and updates a centralized excel sheet
The table at top is how the results are gathered in the Form Results Excel -- I want to understand how to look up the value from colum L:N find the column with information (if it exists) and show the result in the second table (column L)
*There will never be more than 1 value in an individualized row across the length of the array
*ID / Employee Number are both unique values -- I though an Index Match might work but I don't have a constant value the red array I can denote
