External Data, Tables

[The Boondock Saint]

Howdy All
Im important data via a web query, and im just wondering, is there anyway I
can get the input to be put across the page instead of down....

for example, im getting 10 tables, and each table has 5 rows...... so
currently its filling about 60 cells down (including the cell space between
each one)

What Id like it to do.. is put each table.. next to the other one... going
to the right.....

any ideas?

look forward to your thoughts

 

[Arvi Laanemets]

When your query is a once-at-time matter, then after you get your data, you
can use PasteSpecial Transpose to copy data from results table.

When you want to requery later (for case it is something like ODBC queries -
I don't have any experience with web queryes), you can use formulas to turn
the table - better you place the turned table on separate sheet. When your
query result table is always same dimension, you can use a TRANSPOSE
function for it, when length of result table can vary, then you have to
combine OFFSET, ROW and COLUMN functions.