Is there a way to convert rows to columns?
a b c d ...
aa bb cc dd ...
to
a aa
b bb
c cc
d dd
...
Is there a way to convert rows to columns?
a b c d ...
aa bb cc dd ...
to
a aa
b bb
c cc
d dd
...
Copy the data
Select the target area
Edit>Pastespecial and click Transpose.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"asianmike" <[email protected]> wrote
in message news:[email protected]...
>
> Is there a way to convert rows to columns?
>
> a b c d ...
> aa bb cc dd ...
>
> to
>
> a aa
> b bb
> c cc
> d dd
> ..
>
>
> --
> asianmike
> ------------------------------------------------------------------------
> asianmike's Profile:
http://www.excelforum.com/member.php...o&userid=30973
> View this thread: http://www.excelforum.com/showthread...hreadid=507661
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks