| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert multiple columns into a single row
Hi All,
I have an excel sheet with text in 5 columns. I have to get all of these in row and later take that in word. Any help is much appreciated. This is how the excel looks A B C D E i have to convert this to A B C D E |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert multiple columns into a single row
Hi,
Am Sat, 23 Mar 2013 17:40:41 +0000 schrieb dearpt: This is how the excel looks A B C D E i have to convert this to A B C D E copy the values = Paste special = Transpose Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
Hi dearpt
Copy and transpose, or a formula, assuming data is in A1:E1: In A2 & copy down: =INDEX($A$1:$E$1,ROW(1:1)), delete row 1. Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data in columns convert to single line | Excel Worksheet Functions | |||
| How do I convert multiple columns to a single column? | Excel Discussion (Misc queries) | |||
| Convert one row and 50 columns of info to a single printable page | Excel Worksheet Functions | |||
| how to convert multiple columns of data into one single column? | Excel Worksheet Functions | |||
Linear Mode
