Input
col1 | col2 | col3
we | love | cats,dogs
fish | hate | cats
we | eat | fish,cow,rabbit
output
col1 | col2 | col3
we | love | cats
we | love | dogs
fish | hate | cats
we | eat | fish
we | eat | cow
we | eat | rabbit
any idea for a macro that can accomplish this?
col1 | col2 | col3
we | love | cats,dogs
fish | hate | cats
we | eat | fish,cow,rabbit
output
col1 | col2 | col3
we | love | cats
we | love | dogs
fish | hate | cats
we | eat | fish
we | eat | cow
we | eat | rabbit
any idea for a macro that can accomplish this?