Combine data

  • Thread starter Thread starter Prohock
  • Start date Start date
P

Prohock

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
 
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
 
Thanks for the suggestion, but I do not wish to Concatenate the values into
one cell.

I am hoping for a function that would search thru the array A2:F4 and take
the numbers found in every second column (under A, C and E) and place them in
a continual column under H (with the same order as they occur as in A, C and
E). The same would be true for B, D, F and these numbers would be placed
under column I as shown.

The results under H and I must be as follows
H I
2 1
3 1
4 1
3 2
4 2
4 3
 
Back
Top