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

Copy the cells and then use Edit>Paste Special transpose

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



"Raj" <[email protected]> wrote in message news:[email protected]...
> Hi there
>
> I need a huge row of data in excel to be formatted into a column... possible?
>
> Thx
>
> Raj

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

Select the row and Copy.

Select a cell and Paste Special>Transpose.

Delete the original row.


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 13:45:01 -0700, Raj <[email protected]> wrote:

>Hi there
>
>I need a huge row of data in excel to be formatted into a column... possible?
>
>Thx
>
>Raj

thanks, gang

"Raj" wrote:

> Hi there
>
> I need a huge row of data in excel to be formatted into a column... possible?
>
> Thx
>
> Raj