Rows to Columns

maj2834 · Apr 17th, 2002, 09:50 AM

I have a worksheet that has a header row of fields spanning approximately 26 columns. I would like to convert the row of headers to a worksheet that has the row of headers to a worksheet that has the headings in a column. For example, my information is currently in the cells B1, C1, D1, E1, etc. I would like the same information to be in the cells B1, B2, B3, B4, B5, B6, etc. Can anyone help?

Matt · Apr 17th, 2002, 10:00 AM

Copy the data you want to move, instead of pasting the data where you want it moved to, use paste special and tick the transpose box. I think this will give you what you want.

lenze · Apr 17th, 2002, 10:02 AM

Copy, Then Edit-Paste Special-Transpose-OK

maj2834 · Apr 17th, 2002, 10:07 AM

Thank you!! Worked like a charm!!

Quote:

On 2002-04-17 09:00, Matt wrote:
Copy the data you want to move, instead of pasting the data where you want it moved to, use paste special and tick the transpose box. I think this will give you what you want.

maj2834 · Apr 17th, 2002, 10:07 AM

Thank you for your reply!

Quote:

On 2002-04-17 09:02, lenze wrote:
Copy, Then Edit-Paste Special-Transpose-OK

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 09:50 AM	#1
maj2834 New Member Join Date: Apr 2002 Posts: 3	I have a worksheet that has a header row of fields spanning approximately 26 columns. I would like to convert the row of headers to a worksheet that has the row of headers to a worksheet that has the headings in a column. For example, my information is currently in the cells B1, C1, D1, E1, etc. I would like the same information to be in the cells B1, B2, B3, B4, B5, B6, etc. Can anyone help?

Apr 17th, 2002, 10:00 AM	#2
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Copy the data you want to move, instead of pasting the data where you want it moved to, use paste special and tick the transpose box. I think this will give you what you want.

Apr 17th, 2002, 10:02 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Copy, Then Edit-Paste Special-Transpose-OK