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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write select columns to array & back to another spreadsheet 9
compare pairs of columns 3
convert columns to rows 6
Static Web Query 1
Format sheet based on column contents 1
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
How to filter the QueryTable from a Web query 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top