software

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 --gt; Filter --gt; 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

quot;BuckyGeorgequot; wrote:

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

Hi!

Maybe something like this:

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

Copied down as needed.

Biff

quot;BuckyGeorgequot; gt; wrote in message
...
gt;I have data that is 22 cells apart which are related which has data between
gt; them which are 22 cells apart also, i.e. 1's are related, 2's are related
gt; data, etc.
gt; I have currently:
gt; 1
gt; 2
gt; 3
gt; 1
gt; 2
gt; 3
gt; 1
gt; 2
gt; 3
gt; I want:
gt; 1
gt; 1
gt; 1
gt; 2
gt; 2
gt; 2
gt; 3
gt; 3
gt; 3
gt; etc.
gt;
gt; Thanks