Import data not in correct format

Import data reads: Need to do statistical anaysis on hundreds of numbers
and
Cell value # of Cells don't want to enter the numbers by hand.
3 1
4 2

Would like:
Cell Value
3
4
4