Evaluating a variable column list as a string and inserting into a new column formula
I've created a variable that is a string of column names. This is inside a FOR loop so it will change with each loop.Here is a sample table for demonstration, in reality my table is about 400 columns with weird names. I'm trying to group columns that should be grouped and report the max value. 99.9% of the time there will only be 1 value per row for each 'like' column that is to be grouped.Col1C...