According to my understanding: If you want to move the data column 1 to column 2 without calculating the blanks
Use the following formula and press Ctrl+Shift+Enter
=IFERROR(INDEX($A$1:$A$100,SMALL(IF($A$1:$A$100<>"",ROW($A$1:$A$100),""),ROW(A1))),"")