Forum Discussion

NicoleSager's avatar
NicoleSager
Copper Contributor
Apr 26, 2023
Solved

How to Transpose via Formula?

Hello everyone!    I have a table with Contact IDs in column A, and portfolios in column B that are to be assigned to the contact ID. As you can see, there are duplicate contact IDs. I need to redu...
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Apr 26, 2023

    NicoleSager 

    If you're using Excel 365...

     

    =DROP(
    REDUCE(
        "",
        UNIQUE(CID),
        LAMBDA(a, v, LET(filtered, FILTER(AID, CID = v), IFERROR(VSTACK(a, HSTACK(v, TOROW(filtered))), "")))
    ),
    1
)
NicoleSager's avatar
NicoleSager
Copper Contributor
Apr 26, 2023
Thank you so so much for this and for the explanation, you have saved me hours of my time.
Patrick2788's avatar
Patrick2788
Silver Contributor
Apr 26, 2023

You're welcome! Glad to help.

 

The attached is taking the extra step to make this a function called 'Analyze'.  This function is stored as a named item.

 

=Analyze(CID,AID)

 

Resources