how to display data from rows to colum

G

Giridhar

how to display data from rows to colum

Eg
ANDERSON ELECTRONICS INC.
CHENGDU RENHE ELECTRONIC CO., LTD



This to be displayed like below

ANDERSON ELECTRONICS INC CHENGDU RENHE ELECTRONIC CO., LTD
 
D

davesexcel

highlite the two cells and copy=>then paste special=>transpose
you can also join the two cells together by =A1&" "&B1 this will
join the two cells together
 
Top