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.
Thank you for the contribution, this may be a full back option but my workplace is very strict on Macros.
Therefore the formula either LET/LAMBDA would be the preferred option if someone is able to advise
Thanks
Matt