CONCATENATION is the feature that will do as you need.

In H2 put this and copy down
=A2&C2&E2&G2

In I2, put this and copy down
=B2&D2&F2

Vaya con Dios,
Chuck, CABGx3


"Prohock" wrote:

I would like to create a function that I would copy down column H and I that
would take data from every second column i.e. A, C, D and then put it all
into one column H. Then I would like to do the same for column B,D,F and put
the data into column I. Any sugesstions? Please help!

ie
A B C D E F G H I
2 1 3 2 4 3 2 1
3 1 4 2 3 1
4 1 4 1
3 2
4 2
4 3