Mastering the UNIQUE Function in Google Sheets

[@worldspirit3534]

Hi, would you be kind to help me to resolve my issue. i have table with such values: materials, color, input output stock. im using UNIQUE formula to sort that it would not repeat it self. Example: Category, color, SKU, input , output , stock Bead , White , B01 10 , 4 , 6 Tread , Black, B05 6, 3, 3 Magnet Red, B07 8, 2, 6 Green B09 5 1 5 T-White(Tread) T01 T-Orange(Tread) T07 M-Gold(Magnet) M06 I have issue with category when im using UNIQUE forlmula on first 3 columns thats what im getting its sorting but very wierd. what will be your solution if there is? tnx in advance.