column one to column two without blank cell

[white_flag]

Hello I have one column with names but also blank cells. I like to put in an diffrent column data from the first column except the blank cell and if on the first column will add extra data the second column to make an update.. with OFFSET? it is possible?

 

[DauntingGecko]

Can you give as an example of data?

 

[white_flag]

column 1 column2
1________1
5________5
_________8
8________9
9________8
_________9
8________9
_________
9________
9________

like this. and wen an number it is been add to col1 col2 to make an update

 

[Just Jan]

B1 =IF(ISERROR(MATCH(SMALL(C:C,ROW(C1)),C:C,0)),"",INDEX(A:A,MATCH(SMALL(C:C,ROW(C1)),C:C,0)))

C1 =IF(ISNUMBER(A1),ROW(),"")

Copy both formulas down to match col A

 

[white_flag]

work fantastic to numbers. but if I do not have nummbers ?

 

[Just Jan]

Edit; you said in your question "names" bue example was numeric. If so change C1 to =IF(A1)<>"",ROW(),"")

 

[white_flag]

not working

 

[Just Jan]

Sorry remove ) after A1. Should solve problem

 

[white_flag]

thx, it is working very well. But it is possible to be just one formula? I try to make an combination and it is not working