Excel Misc >> convert column and row
Select your range and then Edit|copy
Select a different cell not in the original range
edit|paste special|and check the transpose box.
>
> How can I convert column and row in excel? E.g.
> column1 column2 column3
> a a1 a2 a3
> b b1 b2 b3
>
> I want this format:
> a b
> column1 a1 b1
> column2 a2 b2
> column3 a3 b3
>
> Thanks in advance:cool:
>
> ---
> Message posted from http://www.ExcelForum.com/