copy rows down

  • Thread starter Thread starter rodchar
  • Start date Start date
R

rodchar

hey all,

i have a single column of rows

id,type
1,phone
2,
3,
4,email
5,
6,

is there an easy way to fill in the blanks with the previous non-blank type?

like this?

1,phone
2,phone
3,phone
4,email
5,email
6,email

thanks,
rodchar
 
Select the column.

F5>Special>Blanks>OK

In active blank cell type an = sign the point or arrow to cell above/

CTRL + ENTER to fill in.

Copy/paste special(in place)>values>ok>esc.


Gord Dibben MS Excel MVP
 
Sean read my mind on this one on an earlier reply:
The only fix I can give you is to unmerge the rows. Then, just enter the
person's name in each of the rows. That would fix it.
Click to expand...
Suggestion would be to highlight the column and uncheck merge cells. Then,
in the first blank row, enter = and reference the cell just above. Copy this
formula and do Edit - Go to - Special - Blanks and paste. Copy the column
again and paste-special values to get rid of the formulas...
Click to expand...

Thanks,
rod.
 
Back
Top