Filter once a value in Google Sheets-CodePudding

in working with a formula in Google Sheets so basically I have list of repited institutions and their corresponding ID, like this:

I used this formula to extract the unique values of institutes:

`=IFERROR(INDEX(A2:A24,MATCH(0,INDEX(COUNTIF($C$1:C1,A2:A24),),0)),"")`

It gives me a list of the institutions only once, then I used this formula to do a filter for the ID of that institution:

=TRANSPOSE(IFERROR(FILTER($B$2:$B$24,$A$2:$A$24=D2,$B$2:$B$24<>""),""))

But it gives me a list of multiples times appearing that ID like this:

I would like to have just a list like this:

Please some help with this,

CodePudding user response：

try this formula:

=UNIQUE(A2:B)