title: Google Sheets - How to create a dropdown filter to hide columns?
body: <p>I must have been Googling and trialing/erroring in scripting for 4-5 hours now, I'm stuck in a (frustrating) loop. </p>
  
  <p>I'm trying to create a drop-down filter in A1 which lists all of the values in C1:ZZZ1, and selecting one of the values hides all columns C1:ZZZ1 except the columns that fall under the selected value's merged cell. </p>
  
  <p>Example from the below screenshot:
  In A1 would show a drop-down pulled dynamically, which lists "Joe Adams", "Eagle Nest", and "Sabrina". If I select "Eagle Nest" in the A1 drop-down, all I would see is Column A, Column B, and Columns F, G, and H (since Eagle Nest is merged with these 3 columns). The rest of the columns would be hidden. Then, upon clearing the filter (drop-down), all columns would be visible. Is something like this possible??</p>
  
  <p><a href="https://i.stack.imgur.com/uTFPS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uTFPS.png" alt="enter image description here"></a></p>