Hi All
So I have a report which contains rows of blank cells in between rows that have data. However, in between some of the cells on the rows that has data are also blank cells. I would ideally like to remove ONLY the blank rows and replace any cells that are blank on the rows with data with N/A.
At the moment I am currently highlighing all the blank rows I do this through - GO TO - Special and clicking on the blanks to highlight them) Once the blank rows are highlighted, I paint them a colour and then go through the spread sheet looking for cells that are blank on the rows that have data and manually enter N/A in these.
Once I put N/A in any cells on rows that have data I then delete all the blank rows.
Does anyone have any quick way of entering N/A in one quick go and then allowing me to just delete all the blank rows?
Hope this makes sense and thanks in advance for reading this post and for any help
Bookmarks