Excel question

[BigSmooth]

OK, I have some large data files that, because of the way the software outputs to text, are not organized the way I need them to be.
I am trying to reorganize the data, but I am having trouble with the way the references are working.

Basically, the data I need is contained in every other row and I am trying to condense it so the extra rows aren't there.
So, I want it to move the data like this:
A10 -> B10
A12 -> B11
A14 -> B12
A16 -> B13
A18 -> B14
A20 -> B15

For some reason, I cannot get this to work the way I want it to. I poked around the help but I can't find a formula that will work correctly when I extend it all the way down the spreadsheet.
This seems like such a simple thing that there must be a way to do it!

Can anyone help me with this?

 

[BigSmooth]

Well, I figured out a way to sort of do it using the OFFSET function, although I'm still convinced there must be a simpler way.

 

[NeoV]

the easiest thing would be to make a macro that deletes the blank rows...something like this:

code: Sub DeleteBlankrows()
columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

This looks at each row, column A, and if that cell is blank, it deletes the row...

 

[BigSmooth]

Thanks for the tip. Only problem for this particular purpose is that there is other data in those rows that I don't want to delete. However, such a macro would come in handy for some other spreadsheets I have.