Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine data
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine data
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 "CLR" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to combine data from 2 spreadsheets | New Users to Excel | |||
Combine data - Please help | Excel Worksheet Functions | |||
Combine Data | Excel Worksheet Functions | |||
Need to combine and add data | Excel Discussion (Misc queries) | |||
Combine Data | Excel Discussion (Misc queries) |