| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data in multiple columns moved to one column
Hi Guys
i have a huge amount of data spread across 30+ columns and thousands of rows. is there any way i can move all the data into column A in one movement? Many Thanks. Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data in multiple columns moved to one column
You can use a CONCATENATION formula (with unique separators) in column A,
maybe in two or three blocks, to move all the data to column A, then select column A and do COpy PasteSpecial Values to get rid of the foumulas and keep the concatenated data. Then you can delete the other columns if desired. Not exactly "one movement", but it's the only way I know to do what you ask. Vaya con Dios, Chuck, CABGx3 "Steve" wrote: Hi Guys i have a huge amount of data spread across 30+ columns and thousands of rows. is there any way i can move all the data into column A in one movement? Many Thanks. Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
Linear Mode
