In C2 put the following :

=IF(A2="",A1,A2)

In D2 put the following:

=IF(B2="",B1,B2)

Copy both columns down as required.

Copy, Paste Special--Values (columns C & D) and delete columns A & B

Test first!

HTH


" wrote:

Is there a way we could use excel to fill up any blank with just above
cell's data? For example, I have a data as below:
A B
ID Details
22 ABC
22 ABC
Blank Blank
66 COM
66 COM
Blank Blank
29 TTT
29 TTT
Blank Blank

I have over 1000 lines for this.. Could you please help me with macro
details.. or instruction?? I'm also thinking using find-replace
function. but don't know how to indicate cell above or function. I'm
using MS Excel2000 and 2003. Thank you so much!!