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

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