convert vertical copy table into horizontal table

  • Thread starter Thread starter Java Hop
  • Start date Start date
J

Java Hop

I'm trying to convert a table of information that I
copied off a web page into a horizontal format in Excel.
Is that possible without manually cutting and pasting?

Thank you,

Please reply to javahop @ hotmail.com
 
Hi Java

1) Copy the cells
2) Right click in the cell where you want to paste and choose Paste Special
3) Choose Transpose
4) OK
 
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

convert vertical text file to horizontal and then export to Outlook Contact folder 1
copying/pasting accurately from a Word table (carriage returns) 1
How to Convert same horizontal row to vertical row in Excel? 3
How to copy excel to text in a certain order. 9
formatting vertical lists to horizontal columns 1
PIVOT TABLE Help Please 5
How do you convert a full excel file into a pdf? 2
need to paste link from 4 vertical cells to 4 horizontal cells? 6

Back
Top