Hi!
I am facing a very silly problem. However, I am unable to solve so far.
I have a table with approximately 800 columns and 200 rows.
The ROW 1 is the variable names (800 variables).
I actually only need around 150 variables (I have a list of the variable, column names that should remain).
Thus, 150 columns out of the 800 columns.
However, the names are complicated and to delete each column by looking at it is tricky and time-consuming.
I tried to use the advance filter. However, it was returning only ROW 1 for the 150 columns and deleting the information for these 150 variables, which means, not returning the other 199 rows.
I uploaded a data example of part of my table.
Thank you already for your help!
Bookmarks