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" wrote in message
...
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