Deleting multiple columns

I have a formatted table with columns titled name, age, gender, date of birth, dietary restrictions, etc. I want to delete an entire column if the 'A' row contains a specific value (for example, delete the columns if the cell contains the strings "age" and "gender").

Since out of 27 columns I'll be only be left with 4 in the end, I guess it would make sense to somehow "select" only these four and delete everything that's not selected.

I tried many approaches but for some reason or another it never works as expected. I think something goes wrong when I use a for loop?

Can you give more details please
the 'A' row contains a specific value
Is it the Column A?
What are the specific values?