Columns into row

Hi All,

I have a requirement where I have to read the data in a text file.This
has several rows and columns.I want to transpose data from columns
into rows.
For example,I have data as \


Field1 Field2 Field3 Field4 Field5 Field6
2 Argentina 20071109 35.24 1834.23 60.22
3 Bahrain 20071109 123.48 123.58 128.66
4 Brazil 20071109 14465.41 2207.4 31546.06
5 Chile 20071109 3237.82 1596.79 7086.74
6 China 20071109 193.72 207.08 276.11
7 Colombia 20071109 . . .

This I want to arrange as

2 3
Argentina Bahrain
20071109 20071109
35.24 123.48
1834.23 123.58
60.22 128.66

How to transpose using vba?

Thanks,

Roy