Thread: Combine data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Prohock Prohock is offline
external usenet poster
 
Posts: 12
Default 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