Q: How to display multiple columns in another tab but based on a display on a unique value on certain column I am having trouble displaying the information from another column in googlesheet. I would like to display all the raw data per columns but based on a unique value on certain column. As you can see on column D, those highlighted parts are duplicate values.
enter image description here
I have tried using this formula =UNIQUE(SORT('Supervisor Queue V2'!A2:N,4,TRUE)) but it still display the duplicates on column D. Any help would be appreciated. Thanks in advance.
