Consider using a macro to transpose the data with each web fetch. If you
can't figure it out, send your workbook with clear explanations,
before/after examples, url's etc.to my address below

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Southern at Heart" wrote in
message ...
I have a couple dozen webquerys, which when run, give me about 20 lines of
data, all in a column. I really need each webquery to give the data all
in
one row, so I'll have the same data from all querys in a column. Is this
possible?