data in multiple columns moved to one column

S

Steve

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
 
C

CLR

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
 
Top