Forum Discussion

Matt_Paz's avatar
Matt_Paz
Copper Contributor
Feb 25, 2025
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!
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 26, 2025
    =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.

m_tarler's avatar
m_tarler
Bronze Contributor
Feb 26, 2025

another option without LAMBDA function:

=LET(pp,TRANSPOSE(UNIQUE(project)),
     TOCOL(VSTACK(pp,IF(pp=project,detail,NA())),3,1))

 

Resources