copy & paste multiples

[danalee]

Good morning,

I have a spreadsheet with over 20000 rows.
Scattered among the rows (in no particular pattern) are empty rows.
I need to know if there is a way to have excel look for the empty rows then "copy" the row above the empty row and "paste" into the empty row.

This would be a major help for a project that will be ongoing for years.

Thank you!
DanaLee

 

[yogeshmaney]

plz descript with example

 

[Gerald Higgins]

If you're willing to use helper columns, there is a relatively straightforward way, assuming you only need to do this once.

In the helper column, put something like this on row 2

=if(A2="",+A1,+A2)

and copy down as far as required.
Repeat this for as many columns of data as you actually have.
Once finished, you can use Copy, Paste Special, Values, to "freeze" the result of this formula.

 

[jim may]

Where you do have non-empty rows, are all fields (col A-K, say) non-empty cells?

If so then I'd suggest Highlighting the entire Range;
Get to the Goto Special... Dialog and select BLANKS
At your activecell enter = (then arrow up to the cell just above it) and PRESS CONTROL+Enter (not just enter).
Finally, With Full Range Selected - do a copy pastespecial values to remove formulas
created above.
DONE!!

 

[danalee]

Oh My Gosh!

I wasn't sure it could be done but I knew where to come to ask. This will save so much time for me and my co-workers.

Thank you - Thank you - Thank you

That was from them also


*smile*