transfer a column into a row?

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Is there a way to copy a column of cells and transfer them into a row
of cells?

I get a list of numbers that come to me in a column and I have to
transfer them into a row on another spreadsheet. Right now I'm doing
it manually it would be nice to be able to automate the process
because they all follow the same sequence.
 
Highlight your range of cells in the column (just the range...not the entire
column). Ctrl+C to copy.
Then right-click on the first cell of the row you want these values in.
Select Paste Special.
Check the box for Transpose.
Click OK.

Note: The cell that you want to paste to cannot be part of the copied
range.

HTH,
Paul
 
Highlight your range of cells in the column (just the range...not the entire
column). Ctrl+C to copy.
Then right-click on the first cell of the row you want these values in.
Select Paste Special.
Check the box for Transpose.
Click OK.

Note: The cell that you want to paste to cannot be part of the copied
range.

HTH,
Paul
Click to expand...

thanks!
 

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

Merging multiple columns into one column (dynamically) 1
Copy paste data from a column to a row 0
Need Macro- Insert rows based on dates and copy info from that row 1
Excel Help to copy information from one row at a time to another sheet 1
How do I get more than 255 characters into a cell? 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
columns to rows 4
How to covert rows to columns or columns to rows. 11

Back
Top