Web Query Layout in Worksheet

[- Martin -]

Hi,
I'm trying to import a comma delimited file on a daily
basis from a web page, using Web Query. I've had some
success, but when I've got it what I want as a column is
a row (what should be 'A,B,C ..' is actually '1, 2,
3 ...').
I'm sure this is easily fixed, but I have not found how
to yet.

Thx

 

[Nick Hodge]

Martin

If it is a single column and does not exceed 255 rows, you could copy>paste
special>transpose. This will move the data from a row orientation to a
column.

If it is more than one column you will need code to do it in 'one' go

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)