What formula to use when mixing numbers in a column

[baldi]

I need help with mixing numbers in a column. Is there a function that I can use? I need the column on the left to be mixed between 1 and 2. Then the column on the right to be mixed

1​	1​
1​	2​
1​	3​
1​	4​
1​	5​
1​	6​
1​	7​
1​	8​
1​	9​
2​	1​
2​	2​
2​	3​
2​	4​
2​	5​
2​	6​
2​	7​
2​	8​
2​	9​

 

[awoohaw]

Are you asking for repeated sorting? What version of excel are you using?
And, providing an expected result would be very beneficial to the helping the forum help you.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[baldi]

I'm using excel 2019
the result that I'm looking for is. Column A to have a mixture of 1 and 2. Column B to have a mixture between 1 to 9

 

[awoohaw]

I'm using excel 2019
the result that I'm looking for is. Column A to have a mixture of 1 and 2. Column B to have a mixture between 1 to 9

please describe what you mean by mixture? 1,2,2,1,1,2,2,2,1,1, and 1,4,2,5,3,9,6,7,8 are mixtures but they don't have any kind of pattern or reason.

 

[baldi]

please describe what you mean by mixture? 1,2,2,1,1,2,2,2,1,1, and 1,4,2,5,3,9,6,7,8 are mixtures but they don't have any kind of pattern or reason.

that is exactly what I want. Once I have them mixed. I will merge them to look like this
1-9
1-2
1-3
1-5
1-6
1-8
1-1
1-7
1-4
And then the other set for 2
These are table and seat assignments for a party

 

[awoohaw]

If the sequence function is in 2019, you can use what is on the left, if not use what is on the right:

Book1
	A	B	C
1	1 - 1		1 - 1
2	1 - 2		1 - 2
3	1 - 3		1 - 3
4	1 - 4		1 - 4
5	1 - 5		1 - 5
6	1 - 6		1 - 6
7	1 - 7		1 - 7
8	1 - 8		1 - 8
9	1 - 9		1 - 9
10	2 - 1		2 - 1
11	2 - 2		2 - 2
12	2 - 3		2 - 3
13	2 - 4		2 - 4
14	2 - 5		2 - 5
15	2 - 6		2 - 6
16	2 - 7		2 - 7
17	2 - 8		2 - 8
18	2 - 9		2 - 9
Sheet10

Cell Formulas
Range	Formula
A1:A18	A1	=ROUNDUP(SEQUENCE(18,1,1,1)/9,0)& " - "& MOD(SEQUENCE(18,1,0,1),9)+1
C1:C18	C1	=ROUNDUP(ROW(C1:C18)/9,0)& " - "& MOD((ROW(C1:C18)-1),9)+1
Dynamic array formulas.

 

[Scott Huish]

=LET(s,SEQUENCE(18,,0),INT(s/9)+1&"-"&MOD(s,9)+1)