data in multiple columns moved to one column

[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

[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





"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