Web Query Formatting rows -> columns.

  • Thread starter Thread starter JonathanHenrySchwartz
  • Start date Start date
J

JonathanHenrySchwartz

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
 
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
 
Back
Top