RE: Row to a Column

Select the 4 cells in the column. Copy (control c). Select 4 cells in a row. Edit > Paste Special. Check the TRANSPOSE box. And click ok.

Mangesh

Gets a bit mandraulic doing that hundreds of times for all the rest of the
records though :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"mangesh_yadav" <mangesh_yadav.1qgiea_1118484301.2415@excelforum-nospam.com>
wrote in message
news:mangesh_yadav.1qgiea_1118484301.2415@excelforum-nospam.com...
>
> Select the 4 cells in the column. Copy (control c). Select 4 cells in a
> row. Edit > Paste Special. Check the TRANSPOSE box. And click ok.
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=378277
>