How to copy across the first unique value

[skoorBmaS]

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example,

[TABLE="width: 100"]
<tbody>[TR]
[TD]Description[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[/TR]
</tbody>[/TABLE]

The formula I am currently using is =IF(A2=A3,"-", A2)

This works fine however it will place the word dog in the fourth cell, rather than the second cell which is what I wish to achieve. So the formula should take each unique value and enter them into neighboring cells (E1,F1,G1 etc.)

Hope this makes sense.

 

[Finalfight40]

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example,

[TABLE="width: 100"]
<tbody>[TR]
[TD]Description[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[/TR]
</tbody>[/TABLE]

The formula I am currently using is =IF(A2=A3,"-", A2)

This works fine however it will place the word dog in the fourth cell, rather than the second cell which is what I wish to achieve. So the formula should take each unique value and enter them into neighboring cells (E1,F1,G1 etc.)

Hope this makes sense.

Something like this:

=IFERROR(INDEX($A$2:$A$5, MATCH(0, COUNTIF($C$1:C1, $A$2:$A$5), 0)),"")

It is an array so control + shift + enter and drag down

Ive entered this into C2 and assumed your data is from A2 to A5 so adjust as needed.

 

[Finalfight40]

Just noticed you were dragging right which would mean you would need to change the section in the countif. Redone to drag right it would be:

=IFERROR(INDEX($A$2:$A$5, MATCH(0, COUNTIF($B$2:B2, $A$2:$A$5), 0)),"")