How do I fill (copy) nonadjacent cells to adjacent cells?

B

BuckyGeorge

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
 
J

Jacob_F_Roecker

Here's the quick and easy on this one.

Select your top row that labels your data and then turn on the auto filter
feature

Data --> Filter --> Auto Filter.

You'll then see a drop down on the row above your first column. Click on it
and you'll see you can sort ascending/descending.

This should put all your data in the format you want.

-Jacob F. Roecker
 
Top