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

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

"BuckyGeorge" wrote:

> 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

Hi!

Maybe something like this:

=SMALL(A$1:A$9,ROWS($1:1))

Copied down as needed.

Biff

"BuckyGeorge" <BuckyGeorge@discussions.microsoft.com> wrote in message
news:8E25D17B-1A09-460E-92BA-866C8450DDC7@microsoft.com...
>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