Vstack ignore blanks

[dicken]

Hi,

Is there a better way of using vstack but ignoring the empty cells in each list that this;

VSTACK(FILTER(Table2[A],Table2[A]<>""),FILTER(Table2[B],Table2[B]<>""),FILTER(Table2[C],Table2[C]<>""))

Richard.

 

[johnmpl]

Hi, dicken!

You can shorten your formula like this:

=LET(v,VSTACK(Table2[A],Table2[B],Table2[C]),FILTER(v,v<>""))

or

=TOCOL(Table2[[A]:[C]],1,1)

Blessings!