How many rows are you working with? Are you saying that the format of
your Excel file  is not setup so that the first row  are your labels and
second row through however many are your records you want imported?

That your labels are all in column  A and the data  is in columns B
through IV? IF so, you may want to look at the Transpose feature of a
copy and Paste Special. (Select your labels and data, copy it, move to
a new sheet or book, from the Edit menu, select Paste Special, and then
place a checkmark in Transpose. The labels and data will be rotated.)