I have Googled before anyone says ... can't find the answer I'm looking for 
A colleague has created a shared spreadsheet. I am tasked with tidying up the formatting and making it more easily understandable even though I'm no expert.
Anyway ... he has deleted some of the rows in one of the columns and I don't know how to put it right.
So we currently have 6 columns with 32 rows. But in one of the columns we have some normal rows and then an occasional cell where all the rows are missing. It is a comments column and I think the comment was the same for several rows together and he just didn't want to copy and paste it into all the rows, but I need to change it back to the correct number of rows within the column.
Does anyone understand? Please help! TIA.