How to move text from Row to Column

[soddydj]

How can I move text that are in rows to columns

[swatsp0p]

Hightlight the cells in the row and copy. Select the destination cell and Paste>Special and choose Transpose. Click OK

Does this work for you?

Bruce

[soddydj]

That did not work

Example:

COL.
A B C D E

AC10
AC11
BNB56
SXHD25
EU25F


WANT


A B C D E

AC10 AC11 BNB56 SXHD25 EU25

[soddydj]

Worked Great Thanks:

Soddydj

[Dave Peterson]

Select A1:A5
edit|copy
select a cell not in A1:A5 (b1???).
edit|paste special|Transpose

(delete column A if you want.)

soddydj wrote:
>
> That did not work
>
> Example:
>
> COL.
> A B C D E
>
> AC10
> AC11
> BNB56
> SXHD25
> EU25F
>
> WANT
>
> A B C D E
>
> AC10 AC11 BNB56 SXHD25 EU25
>
> --
> soddydj
> ------------------------------------------------------------------------
> soddydj's Profile: http://www.excelforum.com/member.php...o&userid=25714
> View this thread: http://www.excelforum.com/showthread...hreadid=392163

--

Dave Peterson