Hi,
I am inputting data from multiple tabs and due to a specific column name being different on each of the tabs, I need to find a way to pull the data in each of these columns into 1 column. I have tried using a text input to recreate the issue which you can see in the attached workflow. I have used a formula where I have successfully pulled the relevant data from each column into a new column called Join
The formula is [USBDA]+[USCGM]+[USCICA]+[USSWISS]+[USINTL]
However, the live file that I will be using will have over 30tabs and the column names may change occasionally so I am wondering if there is an easier way to do this.
