adding isblank in a formula

[excelNewbie22]

hi, how to add in the formula isblank for ignoring blanks?

test
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	1	2	3	4	5	6	7	8	9	10	11	12
2	1	2	3	4	5	6	7	8	9	10	11	12
3	7	8	9	10	11	12	0
4
test

Cell Formulas
Range	Formula
A2:L2	A2	=A1:L1
A3:G3	A3	=LET(t,VSTACK(G1:M1),r,ROWS(t),s,SEQUENCE(r*COLUMNS(t),,0),rs,MOD(s,r)+1,cs,INT(s/r)+1,i,INDEX(t,rs,cs),TRANSPOSE(UNIQUE(SORT(FILTER(i,NOT(ISERROR(i)))))))
Dynamic array formulas.

 

[Fluff]

How about

=SORT(UNIQUE(TOROW(G1:M1,1),1),,,1)

 

[excelNewbie22]

i meant with the specific formula, but you still got me in the right direction with torow formula
thank you fluff!

 

[Fluff]

Glad to help & thanks for the feedback.