Rows to Columns

[maj2834]

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]

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]

Copy, Then Edit-Paste Special-Transpose-OK

 

[maj2834]

Thank you!! Worked like a charm!!

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]

Thank you for your reply!

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