<tbody>
Type
Date
Dog
Date
Cat
Date
Dog
1/14/2016
Dog
1/14/2016
Cat
7/8/2018
Dog
5/8/2017
Dog
5/8/2017
Cat
7/8/2018
</tbody>
Given Column A:B, I want to distribute the dog data to the dog columns {C,D} and the cat data to the cat columns {E,F}.
Any ideas?
Thanks!!