Row to Column
 

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.

Brian

Copy the row. Assume row 1

Select A2 and Paste SpecialTransposeOKEsc.


Gord Dibben Excel MVP

On Mon, 6 Dec 2004 16:45:03 -0800, "Brian"
wrote:

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.

Thank you Gord, worked like a charm.

"Gord Dibben" wrote:

Brian

Copy the row. Assume row 1

Select A2 and Paste SpecialTransposeOKEsc.


Gord Dibben Excel MVP

On Mon, 6 Dec 2004 16:45:03 -0800, "Brian"
wrote:

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.

This works great, as long as you don't have more than 256 entries.

"Gord Dibben" wrote:

Brian

Copy the row. Assume row 1

Select A2 and Paste SpecialTransposeOKEsc.


Gord Dibben Excel MVP

On Mon, 6 Dec 2004 16:45:03 -0800, "Brian"
wrote:

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.

bass

OP stated "94 entries" so will have no problem, but thanks for the added
caveat.

Gord

On Tue, 7 Dec 2004 09:53:02 -0800, "crazybass2"
wrote:

This works great, as long as you don't have more than 256 entries.

"Gord Dibben" wrote:

Brian

Copy the row. Assume row 1

Select A2 and Paste SpecialTransposeOKEsc.


Gord Dibben Excel MVP

On Mon, 6 Dec 2004 16:45:03 -0800, "Brian"
wrote:

I have a row with 94 entries.

I would like this data converted to a column instead.

Is there an easy way to accomplish this?

Thank you.