Rotate data in Access2000

I have a CSV file which has 10 rows and 3 columns.
How do I import this data into an Access2000 table so that the rows become the columns and the columns become the rows?