Hi there
I have a worksheet containing c5500 rows. I need to remove the empty cells from Column E onwards, so that there are no blank cells between full cells in the rows.
As an example, F2:BA2 are all blank cells, then BB2:BC2 have data.
I need to remove F2:BA2 so that BB2:BC2 sit F2:G2.
At the moment it is a very manual process, any solutions to do this much more quickly would be greatly appreciated!
Book7.xlsx
thanks
Steve
Bookmarks