building a table using a measure as a column name

I have a table (table1) imported from an Excel spreadsheet with over 100 columns.  The number of columns increases each week. I created a copy of this table (table2) and used the pivot to search the...