[SOLVED] copying cells

[sanpanico]

I am trying to copy data down. I need to fill each of the empty cells with
the data that appears above it before the occurance of the next data item.

For example:

9B0B4C504A70A90B14DFDAB0ADBE477D
-
464EED0D421A8763AE9E539B278257FC
-
-
5B0AB65A11D4BA460000459400000000
-
-
B2D45E0211D550F10100D58698469B02
-

Becomes:
9B0B4C504A70A90B14DFDAB0ADBE477D
9B0B4C504A70A90B14DFDAB0ADBE477D
464EED0D421A8763AE9E539B278257FC
464EED0D421A8763AE9E539B278257FC
464EED0D421A8763AE9E539B278257FC
5B0AB65A11D4BA460000459400000000
5B0AB65A11D4BA460000459400000000
5B0AB65A11D4BA460000459400000000
B2D45E0211D550F10100D58698469B02
B2D45E0211D550F10100D58698469B02


-----------------------
sanpanico

[Peo Sjoblom]

Test this first on a small sample so you are sure you get it right

select the range, press F5, select special and blanks.
Now type in

=A1

(where A1 is the first cell counting from the top, replace it with your
first cell,
i.e. the cell that in your examle holds 9B0B4C504A70A90B14DFDAB0ADBE477D)

press Ctrl + enter

Finally select the new range and copy it, then paste special as values in
place to remove the formula

Done!

Regards,

Peo Sjoblom

"sanpanico" wrote:

> I am trying to copy data down. I need to fill each of the empty cells with
> the data that appears above it before the occurance of the next data item.
>
> For example:
>
> 9B0B4C504A70A90B14DFDAB0ADBE477D
> -
> 464EED0D421A8763AE9E539B278257FC
> -
> -
> 5B0AB65A11D4BA460000459400000000
> -
> -
> B2D45E0211D550F10100D58698469B02
> -
>
> Becomes:
> 9B0B4C504A70A90B14DFDAB0ADBE477D
> 9B0B4C504A70A90B14DFDAB0ADBE477D
> 464EED0D421A8763AE9E539B278257FC
> 464EED0D421A8763AE9E539B278257FC
> 464EED0D421A8763AE9E539B278257FC
> 5B0AB65A11D4BA460000459400000000
> 5B0AB65A11D4BA460000459400000000
> 5B0AB65A11D4BA460000459400000000
> B2D45E0211D550F10100D58698469B02
> B2D45E0211D550F10100D58698469B02
>
>
> -----------------------
> sanpanico