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?
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?
