Break up two columns of 40+ rows into four sets of 2 columns of 10 rows

[paulgunther]

I struggled with the header for this question, let me explain:

I need to take 2 long lists of data in adjacent columns that are too long to fit on a page of print and break them up into multiple "shorter" columns adjacent to each other. The number of rows will vary as the list is updated weekly. The example below should help to explain:

Sunday CP Handicap League 2022.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Handicaps as of:		52 Weeks				Ace Pot
2		6/19/2022						(Max Payout)	$0.00
3
4	HCP	Player	HCP	Player	HCP	Player	HCP	Player	HCP	Player			HCP	Player
5	-23	Player 01	-1	Player 18	-9	Player 35	-5	Player 52	Leader Board				-23	Player 01
6	-9	Player 02	1	Player 19	-23	Player 36	-5	Player 53					-9	Player 02
7	2	Player 03	-7	Player 20	-3	Player 37	-5	Player 54	7	Player 48			2	Player 03
8	-16	Player 04	-16	Player 21	3	Player 38	-6	Player 55	6	Player 11			-16	Player 04
9	-1	Player 05	-13	Player 22	-24	Player 39	0	Player 56	4	Player 16			-1	Player 05
10	-2	Player 06	0	Player 23	3	Player 40	1	Player 57	4	Player 28			-2	Player 06
11	2	Player 07	0	Player 24	3	Player 41	-12	Player 58	3	Player 09			2	Player 07
12	-1	Player 08	0	Player 25	1	Player 42	-2	Player 59	3	Player 10			-1	Player 08
13	3	Player 09	3	Player 26	-18	Player 43			3	Player 26			3	Player 09
14	3	Player 10	-4	Player 27	2	Player 44			3	Player 38			3	Player 10
15	6	Player 11	4	Player 28	-3	Player 45			3	Player 40			6	Player 11
16	0	Player 12	-6	Player 29	-4	Player 46			3	Player 41			0	Player 12
17	-12	Player 13	1	Player 30	-22	Player 47			3	Player 49			-12	Player 13
18	-3	Player 14	-7	Player 31	7	Player 48			2	Player 03			-3	Player 14
19	-1	Player 15	1	Player 32	3	Player 49			2	Player 07			-1	Player 15
20	4	Player 16	-2	Player 33	-16	Player 50			2	Player 44			4	Player 16
21	-8	Player 17	-1	Player 34	1	Player 51							-8	Player 17
22													-1	Player 18
23													1	Player 19
24													-7	Player 20
25													-16	Player 21
26													-13	Player 22
27													0	Player 23
28													0	Player 24
29													0	Player 25
30													3	Player 26
31													-4	Player 27
32													4	Player 28
33													-6	Player 29
34													1	Player 30
35													-7	Player 31
36													1	Player 32
37													-2	Player 33
38													-1	Player 34
39													-9	Player 35
40													-23	Player 36
41													-3	Player 37
42													3	Player 38
43													-24	Player 39
44													3	Player 40
45													3	Player 41
46													1	Player 42
47													-18	Player 43
48													2	Player 44
49													-3	Player 45
50													-4	Player 46
51													-22	Player 47
52													7	Player 48
53													3	Player 49
54													-16	Player 50
55													1	Player 51
56													-5	Player 52
57													-5	Player 53
58													-5	Player 54
59													-6	Player 55
60													0	Player 56
61													1	Player 57
62													-12	Player 58
63													-2	Player 59
Test

Cell Formulas
Range	Formula
I2	I2	=ROUND(IF(I1<330,I1-(I1*0.1),300),0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I5	Cell Value	>-1	text	NO
G17:G21	Cell Value	>-1	text	NO
G12	Cell Value	>-1	text	NO
G11	Cell Value	>-1	text	NO
G13:G16,G5:G10	Cell Value	>-1	text	NO
E17:E21	Cell Value	>-1	text	NO
E12	Cell Value	>-1	text	NO
E11	Cell Value	>-1	text	NO
E13:E16,E5:E10	Cell Value	>-1	text	NO
A17	Cell Value	>-1	text	NO
A16	Cell Value	>-1	text	NO
A5:A15,A18:A21	Cell Value	>-1	text	NO
A1:A4	Cell Value	>-1	text	NO
I1:I4	Cell Value	>-1	text	NO
C17:C21	Cell Value	>-1	text	NO
C12	Cell Value	>-1	text	NO
C11	Cell Value	>-1	text	NO
C13:C16,C5:C10	Cell Value	>-1	text	NO
C1:C4	Cell Value	>-1	text	NO
I6:I21,A22:A1048576	Cell Value	>-1	text	NO

 

[Fluff]

Not sure exactly what you want as your title & sample are different.
This will split the data into 4 sets of 2 columns & the number of rows will vary.

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Handicaps as of:		52 Weeks				Ace Pot
2		6/19/2022						(Max Payout)	0
3
4	HCP	Player	HCP	Player	HCP	Player	HCP	Player	HCP	Player			HCP	Player
5	-23	Player 01	4	Player 16	-7	Player 31	-4	Player 46	Leader Board				-23	Player 01
6	-9	Player 02	-8	Player 17	1	Player 32	-22	Player 47					-9	Player 02
7	2	Player 03	-1	Player 18	-2	Player 33	7	Player 48	7	Player 48			2	Player 03
8	-16	Player 04	1	Player 19	-1	Player 34	3	Player 49	6	Player 11			-16	Player 04
9	-1	Player 05	-7	Player 20	-9	Player 35	-16	Player 50	4	Player 16			-1	Player 05
10	-2	Player 06	-16	Player 21	-23	Player 36	1	Player 51	4	Player 28			-2	Player 06
11	2	Player 07	-13	Player 22	-3	Player 37	-5	Player 52	3	Player 09			2	Player 07
12	-1	Player 08	0	Player 23	3	Player 38	-5	Player 53	3	Player 10			-1	Player 08
13	3	Player 09	0	Player 24	-24	Player 39	-5	Player 54	3	Player 26			3	Player 09
14	3	Player 10	0	Player 25	3	Player 40	-6	Player 55	3	Player 38			3	Player 10
15	6	Player 11	3	Player 26	3	Player 41	0	Player 56	3	Player 40			6	Player 11
16	0	Player 12	-4	Player 27	1	Player 42	1	Player 57	3	Player 41			0	Player 12
17	-12	Player 13	4	Player 28	-18	Player 43	-12	Player 58	3	Player 49			-12	Player 13
18	-3	Player 14	-6	Player 29	2	Player 44	-2	Player 59	2	Player 03			-3	Player 14
19	-1	Player 15	1	Player 30	-3	Player 45			2	Player 07			-1	Player 15
20									2	Player 44			4	Player 16
21													-8	Player 17
22													-1	Player 18
23													1	Player 19
24													-7	Player 20
25													-16	Player 21
26													-13	Player 22
27													0	Player 23
28													0	Player 24
29													0	Player 25
30													3	Player 26
31													-4	Player 27
32													4	Player 28
33													-6	Player 29
34													1	Player 30
35													-7	Player 31
36													1	Player 32
37													-2	Player 33
38													-1	Player 34
39													-9	Player 35
40													-23	Player 36
41													-3	Player 37
42													3	Player 38
43													-24	Player 39
44													3	Player 40
45													3	Player 41
46													1	Player 42
47													-18	Player 43
48													2	Player 44
49													-3	Player 45
50													-4	Player 46
51													-22	Player 47
52													7	Player 48
53													3	Player 49
54													-16	Player 50
55													1	Player 51
56													-5	Player 52
57													-5	Player 53
58													-5	Player 54
59													-6	Player 55
60													0	Player 56
61													1	Player 57
62													-12	Player 58
63													-2	Player 59
64
Report

Cell Formulas
Range	Formula
I2	I2	=ROUND(IF(I1<330,I1-(I1*0.1),300),0)
A5:H19	A5	=LET(f,FILTER(M5:N100,M5:M100<>""),r,ROWS(f),nr,ROUNDUP(r/4,0),s,SEQUENCE(,8,0),IFERROR(INDEX(f,nr*INT(s/2)+SEQUENCE(nr),MOD(s,2)+1),""))
Dynamic array formulas.

 

[paulgunther]

Hi Fluff, thanks for helping me out again. Yes, as I mentioned, I struggled with truncating a title for my question. The total numbers of players will vary from update to update.

I'm unclear on where this formula should be. It will of course be in A5 thru A19, but once I apply it to the next column (C) it no longer works even if I change the cell references.

FYI, I am using shift+ctrl+enter

 

[Fluff]

Do not use Ctrl Shift Enter & the formula just goes in A5. Make sure all other cells in that area are blank.