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.
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.