Importing from Database - can you set up fields by rows instead of col?

I'm using the import data/query wizard to query an external database in Excel. Most of the tables I have created look fine by setting up the queried fields as columns (the default way to do it in Excel) because there are few columns but many rows.

However, I need to create a table that only has one record but many fields to populate. So it would look MUCH better if I could arrange it with two columns and many rows. I can't seem to figure out how to let the wizard set it up to arrange the queried fields by rows instead of columns. Is it even possible?

Originally Posted by spartan

I'm using the import data/query wizard to query an external database in Excel. Most of the tables I have created look fine by setting up the queried fields as columns (the default way to do it in Excel) because there are few columns but many rows.

However, I need to create a table that only has one record but many fields to populate. So it would look MUCH better if I could arrange it with two columns and many rows. I can't seem to figure out how to let the wizard set it up to arrange the queried fields by rows instead of columns. Is it even possible?

If there are not more that 256 columns, you could copy the two rows and Paste Special, and select Transpose,

Does this help?
---