This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thank you very much for your help, but I need something that can be automated. I mean I wont have to manually select all the columns. I have more than 10 tables per sheet with 10 columns each. I am trying not to go to 100 table to tick the right one.
Gaby, i think prior solution makes sense as 1) there is one button how you can select all columns to be included and 2) yes, you would need to manually exclude those empty columns but from your description it seems like there are no more than 10-15 of those columns, so i think you may try to use what Tyler proposed