I need to be able to delete blank cells within a range but not the entire row.
i.e. if the data I want to keep is in column 'T' and I need to keep the header in row 1 so the range would be from T2 down and this end cell will change every day.
When the blank cells are removed I need it to look like this
But I do not want to delete any data from any other cell in any other column.
Can anyone assist?