sort index sequence function showing zero values first

[valmir]

Hello everyone
I need help fixing this formula:
=SORT(INDEX(CG1#;SEQUENCE(ROWS(CG1#));{1\3\2});2;1)
As shown below, it is showing the zero values first on the alphabetically sorted column (middle column).
The sorting is supposed to start on row 24.
Thanks

Stats 2016 - Copy.xlsx
	CS	CT	CU
1	ASA	0	Ady ?
2	BEN	0	Anderson
3	PRO	0	Belito ?
4	4AB	0	Borra
5	4AB	0	Cadiata
6	4AB	0	Chara ?
7	PLS	0	Chico Bel
8	SAG	0	Didí
9	PLS	0	Dji
10	4AB	0	Edi
11	MAI	0	Fernandinho
12	MAI	0	Isaías ?
13	4AB	0	Ivanilson
14	4AB	0	Jesse
15	ASA	0	Kelly
16	4AB	0	Lara ?
17	MAI	0	Mano ?
18	PLS	0	Mayala
19	POR	0	Miguel ?
20	ACA	0	Nzuzi
21	4AB	0	Rui ?
22	ASA	0	Tucho ?
23	LIB	0	Yuri ?
24	PLS	Abel Lukango	Abel
25	DES	Abelardo Gomes Socola	Belito Socola
26	DES	Abengea Mambani Ali	Ali
27	DES	Adão Francisco Congo Zalata	Dadão Bile
28	PRI	Adão Joaquim Bango Cabaça	Tony Cabaça
29	CAA	Adelino Wima Calunhi António	Maninho
30	MAI	Adérito Yandelela Chissoca	Lelas
31	SAG	Adérito Yandelela Chissoca	Lelas
32	INT	Adilson Cipriano da Cruz	Neblú
33	LIB	Adilson Ernesto Kivão	Adilson Kivão
34	CAA	Adilson Joaquim Manuel	Adilson Manuel
35	POR	Adolfo da Silva Catemba	Denilson
36	SAG	Adolfo da Silva Catemba	Denilson
37	PRO	Adriano Belmiro Duarte Nicolau	Yano
38	DES	Adriano da Costa Mateus Alberto	Kumaca
39	ASA	Afonso Sebastião Cabungula	Fofó
STATS2

 

[Eric W]

I'm not exactly sure what you want, but maybe:

=IFERROR(SORT(INDEX(IF(CG1#=0;NA();CG1#);SEQUENCE(ROWS(CG1#));{1\3\2});2;1);"")

 

[valmir]

=IFERROR(SORT(INDEX(IF(CG1#=0;NA();CG1#);SEQUENCE(ROWS(CG1#));{1\3\2});2;1);"")

Thank you sir, it moved those 23 empty rows to the bottom, now is it possible to eliminate them, please?

 

[Fluff]

Maybe

+Fluff 1.xlsm
	G	H	I	J	K	L	M	N
1	4AB	Borra	0			PLS	Abel Lukango	Abel
2	4AB	Cadiata	0			DES	Abelardo Gomes Socola	Belito Socola
3	4AB	Chara ?	0			DES	Abengea Mambani Ali	Ali
4	4AB	Edi	0			DES	Adão Francisco Congo Zalata	Dadão Bile
5	4AB	Ivanilson	0			PRI	Adão Joaquim Bango Cabaça	Tony Cabaça
6	4AB	Jesse	0			CAA	Adelino Wima Calunhi António	Maninho
7	4AB	Lara ?	0			MAI	Adérito Yandelela Chissoca	Lelas
8	4AB	Rui ?	0			SAG	Adérito Yandelela Chissoca	Lelas
9	ACA	Nzuzi	0			INT	Adilson Cipriano da Cruz	Neblú
10	ASA	Ady ?	0			LIB	Adilson Ernesto Kivão	Adilson Kivão
11	ASA	Kelly	0			CAA	Adilson Joaquim Manuel	Adilson Manuel
12	ASA	Tucho ?	0			POR	Adolfo da Silva Catemba	Denilson
13	ASA	Fofó	Afonso Sebastião Cabungula			SAG	Adolfo da Silva Catemba	Denilson
14	BEN	Anderson	0			PRO	Adriano Belmiro Duarte Nicolau	Yano
15	CAA	Maninho	Adelino Wima Calunhi António			DES	Adriano da Costa Mateus Alberto	Kumaca
16	CAA	Adilson Manuel	Adilson Joaquim Manuel			ASA	Afonso Sebastião Cabungula	Fofó
17	DES	Belito Socola	Abelardo Gomes Socola
18	DES	Ali	Abengea Mambani Ali
19	DES	Dadão Bile	Adão Francisco Congo Zalata
20	DES	Kumaca	Adriano da Costa Mateus Alberto
21	INT	Neblú	Adilson Cipriano da Cruz
22	LIB	Yuri ?	0
23	LIB	Adilson Kivão	Adilson Ernesto Kivão
24	MAI	Fernandinho	0
25	MAI	Isaías ?	0
26	MAI	Mano ?	0
27	MAI	Lelas	Adérito Yandelela Chissoca
28	PLS	Chico Bel	0
29	PLS	Dji	0
30	PLS	Mayala	0
31	PLS	Abel	Abel Lukango
32	POR	Miguel ?	0
33	POR	Denilson	Adolfo da Silva Catemba
34	PRI	Tony Cabaça	Adão Joaquim Bango Cabaça
35	PRO	Belito ?	0
36	PRO	Yano	Adriano Belmiro Duarte Nicolau
37	SAG	Didí	0
38	SAG	Lelas	Adérito Yandelela Chissoca
39	SAG	Denilson	Adolfo da Silva Catemba
Main

Cell Formulas
Range	Formula
G1:I39	G1	=INDEX(A1:C39,0,)
L1:N16	L1	=SORT(SORTBY(FILTER(G1#,INDEX(G1#,,3)<>0),{1,3,2}),2,1)
Dynamic array formulas.

 

[valmir]

Maybe

+Fluff 1.xlsm
	G	H	I	J	K	L	M	N
1	4AB	Borra	0			PLS	Abel Lukango	Abel
2	4AB	Cadiata	0			DES	Abelardo Gomes Socola	Belito Socola
3	4AB	Chara ?	0			DES	Abengea Mambani Ali	Ali
4	4AB	Edi	0			DES	Adão Francisco Congo Zalata	Dadão Bile
5	4AB	Ivanilson	0			PRI	Adão Joaquim Bango Cabaça	Tony Cabaça
6	4AB	Jesse	0			CAA	Adelino Wima Calunhi António	Maninho
7	4AB	Lara ?	0			MAI	Adérito Yandelela Chissoca	Lelas
8	4AB	Rui ?	0			SAG	Adérito Yandelela Chissoca	Lelas
9	ACA	Nzuzi	0			INT	Adilson Cipriano da Cruz	Neblú
10	ASA	Ady ?	0			LIB	Adilson Ernesto Kivão	Adilson Kivão
11	ASA	Kelly	0			CAA	Adilson Joaquim Manuel	Adilson Manuel
12	ASA	Tucho ?	0			POR	Adolfo da Silva Catemba	Denilson
13	ASA	Fofó	Afonso Sebastião Cabungula			SAG	Adolfo da Silva Catemba	Denilson
14	BEN	Anderson	0			PRO	Adriano Belmiro Duarte Nicolau	Yano
15	CAA	Maninho	Adelino Wima Calunhi António			DES	Adriano da Costa Mateus Alberto	Kumaca
16	CAA	Adilson Manuel	Adilson Joaquim Manuel			ASA	Afonso Sebastião Cabungula	Fofó
17	DES	Belito Socola	Abelardo Gomes Socola
18	DES	Ali	Abengea Mambani Ali
19	DES	Dadão Bile	Adão Francisco Congo Zalata
20	DES	Kumaca	Adriano da Costa Mateus Alberto
21	INT	Neblú	Adilson Cipriano da Cruz
22	LIB	Yuri ?	0
23	LIB	Adilson Kivão	Adilson Ernesto Kivão
24	MAI	Fernandinho	0
25	MAI	Isaías ?	0
26	MAI	Mano ?	0
27	MAI	Lelas	Adérito Yandelela Chissoca
28	PLS	Chico Bel	0
29	PLS	Dji	0
30	PLS	Mayala	0
31	PLS	Abel	Abel Lukango
32	POR	Miguel ?	0
33	POR	Denilson	Adolfo da Silva Catemba
34	PRI	Tony Cabaça	Adão Joaquim Bango Cabaça
35	PRO	Belito ?	0
36	PRO	Yano	Adriano Belmiro Duarte Nicolau
37	SAG	Didí	0
38	SAG	Lelas	Adérito Yandelela Chissoca
39	SAG	Denilson	Adolfo da Silva Catemba
Main

Cell Formulas
Range	Formula
G1:I39	G1	=INDEX(A1:C39,0,)
L1:N16	L1	=SORT(SORTBY(FILTER(G1#,INDEX(G1#,,3)<>0),{1,3,2}),2,1)
Dynamic array formulas.

Dear Sir
Is there another solution even with another formula? Basically what I am trying to accomplish is to make the three source columns (A,B,C) into the three target columns (D,E,F). Source column C becomes column E (alphabetically sorted) with its corresponding matches. Please note that empty values in B and C should not appear.
Please take a look at source and desired target

Stats 2016 - Copy.xlsx
	A	B	C	D	E	F
1	4AB	Borra	0	PLS	Abel Lukango	Abel
2	4AB	Cadiata	0	DES	Abelardo Gomes Socola	Belito Socola
3	4AB	Campos	António Campos Calei	DES	Abengea Mambani Ali	Ali
4	4AB	Chara ?	0	DES	Adão Francisco Congo Zalata	Dadão Bile
5	4AB	Dany Ribeiro	Daniel Mendes Ribeiro	PRI	Adão Joaquim Bango Cabaça	Tony Cabaça
6	4AB	Dário Amorim	Dário Félix Amorim	CAA	Adelino Wima Calunhi António	Maninho
7	ACA	Adó Pena	António Joaquim Barros Pena	MAI	Adérito Yandelela Chissoca	Lelas
8	ACA	Aires	Ludgero Aires Cachicote da Rocha	SAG	Adérito Yandelela Chissoca	Lelas
9	ACA	Borges	Cláudio Ricardo Cunha Borges	INT	Adilson Cipriano da Cruz	Neblú
10	ACA	Cabibi Abreu	Mário Rui de Abreu	LIB	Adilson Ernesto Kivão	Adilson Kivão
11	ACA	Camota	Júlio Camota Marcelino Tito	CAA	Adilson Joaquim Manuel	Adilson Manuel
12	ACA	Chabalala	Gaspar Necas Fortunato	POR	Adolfo da Silva Catemba	Denilson
13	BEN	Amaro	Amândio Manuel Filipe da Costa	SAG	Adolfo da Silva Catemba	Denilson
14	BEN		0	PRO	Adriano Belmiro Duarte Nicolau	Yano
15	BEN	Amido Baldé	Amido Baldé	DES	Adriano da Costa Mateus Alberto	Kumaca
16	BEN	Anderson	0	ASA	Afonso Sebastião Cabungula	Fofó
17	BEN	Baby	Valdemar Denso António	INT	Agostinho Cristóvão Paciência	Mabululu
18	BEN	Bena	Diveluca Simão Nascimento	BEN	Agostinho Domingos Paulo	Ady Paulo
19	BEN	Borges	Cláudio Ricardo Cunha Borges	KAB	Aires Emilson Gonzaga Zeca	Emilson
20	BEN	Debele	Edgar Elias Hebo Kissanga	MAI	Albano Camuele Sumano	Pai da Bola
STATS2

Cell Formulas
Range	Formula
B1	B1	=INDIRECT("4AB!B5")
C1	C1	=INDIRECT("4AB!C5")
B2	B2	=INDIRECT("4AB!B6")
C2	C2	=INDIRECT("4AB!C6")
B3	B3	=INDIRECT("4AB!B7")
C3	C3	=INDIRECT("4AB!C7")
B4	B4	=INDIRECT("4AB!B8")
C4	C4	=INDIRECT("4AB!C8")
B5	B5	=INDIRECT("4AB!B9")
C5	C5	=INDIRECT("4AB!C9")
B6	B6	=INDIRECT("4AB!B10")
C6	C6	=INDIRECT("4AB!C10")

 

[Fluff]

Doesn't the formula I showed in L1 do that for you?

 

[valmir]

Doesn't the formula I showed in L1 do that for you?

In this case I will have a repetition of columns G, H and I? Because I already have those as the source columns. Can you please make me understand?

 

[Fluff]

You originally posted a formula that looks at a spill range & asked for it to be modified, which Eric & I have done.
If that is not what you wanted, then why did you ask?

 

[valmir]

Doesn't the formula I showed in L1 do that for you?

You originally posted a formula that looks at a spill range & asked for it to be modified, which Eric & I have done.
If that is not what you wanted, then why did you ask?

If you notice, that's exactly what I asked. Eric's solution solved part of the problem, it didn't eliminate the empty rows, it moved them to the bottom, your solution, on the other hand, requires having a repetition of the three columns, which I don't want, if I understood well your solution. I was thinking that it would be easier for you guys to "fix" that formula, otherwise, if there was an easier or more direct way of doing it, come up with another formula. That's the only reason why I showed you the source and target columns, maybe for you to better understand what I want.

 

[Fluff]

My solution works on the spilled range that your formula works on.
I created some scrap data in G1 to represent your data in CG1 & then the formula in L1 is to replace the formula you posted in your op.