[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Type[/TD]
[TD]Date[/TD]
[TD]Dog[/TD]
[TD]Date[/TD]
[TD]Cat[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]1/14/2016[/TD]
[TD]Dog[/TD]
[TD]1/14/2016[/TD]
[TD]Cat[/TD]
[TD]7/8/2018[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]5/8/2017[/TD]
[TD]Dog[/TD]
[TD]5/8/2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]7/8/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!!
<tbody>[TR]
[TD]Type[/TD]
[TD]Date[/TD]
[TD]Dog[/TD]
[TD]Date[/TD]
[TD]Cat[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]1/14/2016[/TD]
[TD]Dog[/TD]
[TD]1/14/2016[/TD]
[TD]Cat[/TD]
[TD]7/8/2018[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]5/8/2017[/TD]
[TD]Dog[/TD]
[TD]5/8/2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]7/8/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!!
Last edited: