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,
<tbody>
</tbody>
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.
Description |
Cat |
Cat |
Cat |
Dog |
<tbody>
</tbody>
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.