| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing colum data and exporting | Excel Discussion (Misc queries) | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Linear Mode
