Concatenate multiple columns into one column in a table/excel

Options
Lopez_211881
Lopez_211881 Posts: 8
edited February 2023 in Questions

Hi,
May I know how do I concatenate/combine multiple columns into one column in a table that is dynamically changing?

I have a mapping table below and would like to be able to dynamically combine the values of all the columns into one column "Combine".
I'll be using this column to match it with another table and return the result in the Status column.
Is this possible?
The only way I have tried is to manually get all the values using the "If/ else if".

Thanks