Pasting from Web Tables

[todaresq]

Hey all, I am trying to paste a row from a table online into an Excel worksheet. Instead of going accross the columns in one row, it appears down one column, down a bunch of rows.

Each cell from the website still appear in a different cell in Excel, it just goes down instead of accross.

Any ideas how to fix it so that when I paste it goes accross?

[samprince]

I would suggest using the built in Web Query feature in Data, Import External Data menu.

Then just take what you want from the data you import.