Transposing an imported Excel file

[catherinebrunet]

I am seeking to import an Excel file into Eviews8, the dataset is relatively large (500 variables x 50 years) such that the data is set horizontally a opposed to vertically. As such, I need to transpose the data prior to importing it (please see the attached Excel file for an example of how the data is structured). I usually import data, for vertically-oriented Excel files, with the following command:

pageselect A3260031
import "path\CANSIM 326-0031.xls" range="Eviews" colhead=2 namepos=first @freq A 1960

What should I add to make sure the data is transposed? Thank you much in advance!

[EViews Gareth]

Add "byrow" as an argument prior to the range argument

[catherinebrunet]

Add "byrow" as an argument prior to the range argument

This works perfectly, thank you!