Transposing a row into a column
 

Hi there

I need a huge row of data in excel to be formatted into a column... possible?

Thx

Raj

Transposing a row into a column
 

Copy the cells and then use EditPaste Special transpose

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Raj" wrote in message ...
Hi there

I need a huge row of data in excel to be formatted into a column... possible?

Thx

Raj

Transposing a row into a column
 

You already have the answer Raj! You need to transpose it. Copy the row,
select the starting row for your destination, click Edit|Paste Special and
select Transpose


"Raj" wrote:

Hi there

I need a huge row of data in excel to be formatted into a column... possible?

Thx

Raj

Transposing a row into a column
 

thanks, gang

"Raj" wrote:

Hi there

I need a huge row of data in excel to be formatted into a column... possible?

Thx

Raj

Transposing a row into a column
 

Select the row and Copy.

Select a cell and Paste SpecialTranspose.

Delete the original row.


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 13:45:01 -0700, Raj wrote:

Hi there

I need a huge row of data in excel to be formatted into a column... possible?

Thx

Raj