How do you display values from an array without blanks, zeros, repeating a number?

[arthurz11]

 

[myall_blues]

Try this. VSTACK unfortunately not available in your version.

=LET(z,FILTERXML("<x><y>"&SUBSTITUTE(TEXTJOIN(",",,TRANSPOSE(A1:B5)),",","</y><y>")&"</y></x>","//y"),UNIQUE(FILTER(z,z<>0)))

As an aside, you need to think twice about the spelling in your signature.

 

[hagia_sofia]

Another option:

=LET(
a,A1:A5,
b,B1:B5,
ra,ROWS(a),
rb,ROWS(b),
rsq,SEQUENCE(ra+rb),
csq,SEQUENCE(,COLUMNS(a)),
array,IFS(rsq<=ra,INDEX(a,rsq,csq),rsq<=ra+rb,INDEX(b,rsq-ra,csq)),
UNIQUE(FILTER(array,array<>0)))

 

[arthurz11]

Whoa! It worked super great! That was perfect and it even worked with text which I didn't expect. Awesome work!!!!! Thank you so much!

 

[myall_blues]

You're welcome - thanks for the feedback.