I have sheets with data in adjoining columns. Not every cell has data. I want
to removed all the empty cells and leave only a full page of data. At the
moment the only way I can think of is advance filtering for non-blanks but I
have to do this for each individual column which is time consuming (multiple
sheets etc)
Alternatively would there be a way of filtering all the columns for
specific words and returning only cells that meet certain criteria