Filling in Cell above with Data from below

[CUTiger]

Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on:

Col A
123
XXX
345
YYY
Need it to end up like:

XXX
XXX
YYY
YYY

How can I do this?

 

[sami]

visit www.ExcelGoodies.com

 

[Luke M]

If A1 and A3 are blank:
Select A1:A4. Press Ctrl+G. Click special, blank.

Start typing a formula:
=

Then press the down arrow key. This should finish the formula and create:
=A2

Press Ctrl+Enter to apply formula to all currently selected cells.
If needed, you could then do a copy, paste special - values only.
=======

If A1 and A3 are not blank, but you want every other line copied upward:
In helper column B, cell B1:

=IF(MOD(ROW(),2),A2,A1)

Copy down as needed.

 

[CUTiger]

Worked great!!!!!!!!!Thanks for the help

CUTiger