Forum Discussion
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!
Edit: Added example file.
There are 2 lists, list A and list B. My goal is to create another list which consists of the unique values of list A and list B. In the example file I achieved this by simply using the Unique function for list A and list B seperatly in column E and then use the unique function again for the range in column E in column G.
The problem is that this method breaks if I increase the number of unique items in list A, as the cell for the dynamic array is already occupied.
So my question is there a way to do this with the new dynamic arrays that is not dependant on the number of entries and unique items?
- Additional Info: UNIQUE function https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e?ui=en-us&rs=en-us&ad=us I would be happy to know if I could help. Nikolino I know I don't know anything (Socrates)
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)Thanks for the reply. I added a file and some more text in the opening post as per your advice.
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()
