Web Query Formatting rows - columns.
 

I'm having a problem where I have a web query looking at an XML file.
When it spits it into the spreadsheet, its formatted in rows. The
problem is, it doesn't have enough space to spit out the whole feed.
I need it to be formatted into columns. It needs to do this
autonomously while its getting the data for the web query...

Any advice?

Thanks,

Jon Schwartz

Web Query Formatting rows - columns.
 

Jon,
Not sure I understand; if there are more than 65K rows, it will not fit in
256 columns (assuming not XL2007.
At a guess, look at AutoFit and/or TextToColumns.

Otherwise, explain what you mean by "it doesn't have enough space to spit
out the whole feed".

NickHK

wrote in message
oups.com...
I'm having a problem where I have a web query looking at an XML file.
When it spits it into the spreadsheet, its formatted in rows. The
problem is, it doesn't have enough space to spit out the whole feed.
I need it to be formatted into columns. It needs to do this
autonomously while its getting the data for the web query...

Any advice?

Thanks,

Jon Schwartz