Transposing data from columns to rows

A

Annalise Vogel

Hi,

I have cut and pasted a table from an online database into a spreadsheet.

It has pasted into one column.

How can I format the data so that each entry appears in one row across
various columns.

Currently I am transposing each entry individually by paste special.

Help! I have 300 to do!
 
P

Peo Sjoblom

Why don't you use data>import external data>web query

--
Regards,

Peo Sjoblom

(No private emails please)
 
A

Annalise Vogel

Why don't you use data>import external data>web query
Click to expand...
Because the database doesn't download into excel, and I don't have
ODBC......anyone else have an easy explanation.
 
A

Alan Beban

Annalise said:
Because the database doesn't download into excel, and I don't have
ODBC......anyone else have an easy explanation.
Click to expand...
Copy the entire column, and Paste Special into the entire row using the
Transpose option.

Alan Beban
 
A

Alan Beban

Alan said:
Copy the entire column, and Paste Special into the entire row using the
Transpose option.

Alan Beban
Click to expand...
But you can't do 300 because you only have 256 columns.

Alan Beban
 

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

Embed the same Excel multiple times 0
Adding a big matrix in Word 2013 5
Merging from an Excel file with graphics 1
Need Help with a VBA subroutine 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Eliminate blanks while copy row and transpose 11
Mailing address block: sorting 1 row to columns 1
Transposing excel column in to row 1

Top