Forum Discussion

Swengineer's avatar
Swengineer
Copper Contributor
Oct 07, 2020

How to combine columns into a single one

Hello   I want to use the new "Unique" function on multiple columns and get the list of unique values in a single column, is there a way to do that using the new dynamic arrays?   Thanks!   Edi...
Formulas and Functions
Swengineer's avatar
Swengineer
Copper Contributor
Oct 07, 2020

NikolinoDE 

 

Thanks for the reply. I added a file and some more text in the opening post as per your advice.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 09, 2020

Swengineer 

That could be like

=SORT(UNIQUE(INDEX($A$2:$D$19,MOD(SEQUENCE(2*18)-1,18)+1,INT(SEQUENCE(2*18,,18)/18))))

concrete size you may calculate by COUNTA()

      • carlsenk's avatar
        carlsenk
        Copper Contributor
        Jul 19, 2022
        Today you taught me something too. Great technique with UNIQUE (spills) and SEQUENCE. Thank you.

Resources