I'm trying to create a second drop down that encapsulates all of the column headers. I.e., pare down a table by filtering by row, and then filtering by column. Basically, get this table...... down to a 1v1 level. E.g., select "Jack Black" in the drop...

I am trying to display this Google Sheet table in a filterable table in Google Looker:It's easy enough to bring it in, so that it looks like this:Every column header has to be brought in as a metric, which works, but I'd like to have two filters at t...