"I have a process where I need to create a summary from several reports. These reports contain many columns with different names, and sometimes, certain columns won’t be used.
The first column in the image represents the fixed column names in my summary. The ‘America’ column is an example of how the report columns from America should be mapped. However, the challenge arises when the column shows ‘Sheet Name’—in this case, I need to pull the value for ‘Load In’ from another string variable. If the result is ‘-’, I will leave the column empty.
Do you have any ideas on how to achieve this?"
