Forum Discussion
Solved
Combining two columns in a table into one ordered list
Hi all Hope you are well! I know how to use VSTACK in order to get two columns of data into one column. However, my needs are a little more bespoke. How would I solve this below? Thank you!
=DROP(REDUCE("",UNIQUE(A1:A14),LAMBDA(u,v,VSTACK(u,v,FILTER(B1:B14,A1:A14=v)))),1)If you work with the latest version of Excel you can use this formula.
=DROP(REDUCE("",UNIQUE(A1:A14),LAMBDA(u,v,VSTACK(u,v,FILTER(B1:B14,A1:A14=v)))),1)If you work with the latest version of Excel you can use this formula.