What determines which go into each of your 2 new ones?

=ABC!A2&" "&ABC!B2&" "&ABC!C2
then
=ABC!D2&" "&ABC!E2&" "&ABC!F2

would work...

"Mike" wrote:

Hi,

Say in sheet named ABC, I have data in 6 columns [(A, B), (C, D), (E,
F)] their lengths vary, which I want to move into sheet BBB and put
them ALL in 2 columns only (A, B)....i.e. append them

What is the smart way to do so?

Thanks,
Mike
.