View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BuckyGeorge
 
Posts: n/a
Default How do I fill (copy) nonadjacent cells to adjacent cells?

I have data that is 22 cells apart which are related which has data between
them which are 22 cells apart also, i.e. 1's are related, 2's are related
data, etc.
I have currently:
1
2
3
1
2
3
1
2
3
I want:
1
1
1
2
2
2
3
3
3
etc.

Thanks