data

M

melle

Hi,

I transported data into excel.

I have values in A10, A20, A30, A40 etc.... A1000

I want to delete all the empty cells.

So, B1 should be A10
B2 should be A20
B3 should be A30
B4 should be A40


If I enter the formula in B1: =A10
B2: =A20
etc.


I cannot copy the formula, if I copy it the formula in B3 is A12 and
it should be A30.



I hope someone can help me.
 
S

swatsp0p

Place this formula in B1 and copy down as far as needed:

=INDEX($A$1:$A$1000,ROW()*10,1)

B1=A10
B2=A20
B3=A30....

HTH

Bruce
 
M

melle

Bruce,

From the Netherlands. Thank's a lot. This saves me a great deal of
time.

Regards,

Melle
 
R

René

The fastest way think is the following:
Since all the A-cell are 10 cells apart from eachother, make an index
in column C. So C1: 10, C2: 20,....etc. (you can easlily copy down).
Then in B1: =INDEX(A:A;C1;1) and copy down.
 
Top