ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   webquery needs to import to row, not column (https://www.excelbanter.com/excel-programming/422396-webquery-needs-import-row-not-column.html)

Southern at Heart

webquery needs to import to row, not column
 
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?

Don Guillett

webquery needs to import to row, not column
 
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?




All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com