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
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 07, 2020

Swengineer 

If I can recommend you, add a file (without sensitive data) and describe your plan on it. This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered. So everyone is helped.

Help to be helped.

 

* It's always good to add your operating system and Excel version.

 

As far as I know, here is some information that might help you.

 

UNIQUE function

https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e

 


Thank you for your understanding and patience

Nikolino
I know that I don't know (Socrates)

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()

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 07, 2020
    I don't really know my way around Office 365 ... I'm still studying.
    Here is a page that may help you.

    https://www.myonlinetraininghub.com/excel-functions/excel-unique-function

    * But I am sure that one of the experts here will take care of your request now that you have a file and suggest the appropriate solution for you.

    Thank you for your understanding and patience

    Nikolino
    I know that I don't know (Socrates)

Resources