Forum Discussion
Combining two columns into one ordered list
Hi all Problem trying to solve. I have a table of data like as follows: I know how to VSTACK, but how would I order by project and only repeat the project once with any matching rows in column...
=DROP(REDUCE("",UNIQUE(A1:A15),LAMBDA(u,v,VSTACK(u,v,FILTER(B1:B15,A1:A15=v)))),1)With the latest version of Excel you can use this formula.