RE: Row to a Column

Hi there,
I have a group of rows and want to transpose them to a columns.

say I have column of address
(four rows,
Address,
city,
state
zip) and each address is saperated by blank rows.
I want to transpose each address into a column. Is there a way to do this in
excell?


wilde wood ave
Lake land
FL
90010

Little rock rd
San diago
CA
92345


Result after transpose

wilde wood ave Lake land FL 90010
Little rock rd San diago CA 92345




any help appricated.

Thanks
-Murali

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

Assuming your data is in A1:A1000, then in B1 put

=OFFSET($A$1,ROW()*5-(7-COLUMN(B1)),0)

Then simply copy to B1:E200

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

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

"Murali" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
> I have a group of rows and want to transpose them to a columns.
>
> say I have column of address
> (four rows,
> Address,
> city,
> state
> zip) and each address is saperated by blank rows.
> I want to transpose each address into a column. Is there a way to do this
in
> excell?
>
>
> wilde wood ave
> Lake land
> FL
> 90010
>
> Little rock rd
> San diago
> CA
> 92345
>
>
> Result after transpose
>
> wilde wood ave Lake land FL 90010
> Little rock rd San diago CA 92345
>
>
>
>
> any help appricated.
>
> Thanks
> -Murali

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>