ExcelBanter - how to display data from rows to colum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to display data from rows to colum (https://www.excelbanter.com/excel-discussion-misc-queries/76648-how-display-data-rows-colum.html)

Giridhar

how to display data from rows to colum

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

davesexcel

how to display data from rows to colum

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

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521317

All times are GMT +1. The time now is 05:42 PM.