How to move text from Row to Column
 

How can I move text that are in rows to columns


--
soddydj
------------------------------------------------------------------------
soddydj's Profile: http://www.excelforum.com/member.php...o&userid=25714
View this thread: http://www.excelforum.com/showthread...hreadid=392163

Hightlight the cells in the row and copy. Select the destination cell
and PasteSpecial and choose Transpose. Click OK

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=392163

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

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

Worked Great Thanks:

Soddydj


--
soddydj
------------------------------------------------------------------------
soddydj's Profile: http://www.excelforum.com/member.php...o&userid=25714
View this thread: http://www.excelforum.com/showthread...hreadid=392163