Transposing a row into a column

[Raj]

Hi there

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

Thx

Raj

 

[Ron de Bruin]

Copy the cells and then use Edit>Paste Special transpose

 

[kassie]

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]

thanks, gang

 

[Gord Dibben]

Select the row and Copy.

Select a cell and Paste Special>Transpose.

Delete the original row.


Gord Dibben MS Excel MVP