Copying Column Data and Pasting it into a Row

  • Thread starter Thread starter Hulk
  • Start date Start date
H

Hulk

Is it possible to take data in a single COLUMN on a worksheet and past
it into a ROW on another worksheet in the same workbook?

Obviously, I could do this manually but I would like to do it with
few mouse strokes as there is a lot of data.

Thanks!

Hul
 
In the first cell in the row that you want to copy it to put =A1 an
then copy across the row

A1 being your first cell in the column you want to copy
 
Assuming you include clicking on options in menus and dialog boxes as mouse
strokes, you must Copy, then Edit/Paste Special and select the TRANSPOSE
option.
 
Copy>Paste Special>Transpose.

NOTE: you will be limited to 256 entries going from column to row.

Gord Dibben Excel MVP
 
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

Copy paste data from a column to a row 0
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Transposing a pasted link row into a column 3
Excel Help to copy information from one row at a time to another sheet 1
bringing data from a column to a row in a formula 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy-Paste Chart into Word from Excel 2007 3

Back
Top