I have a list like the one shown below: | Owner | Alone? | | _________ | __________ | | Mickey | Yes | | Goofy | Yes | | Pluto | Yes | | Pluto / Mickey | No | | Minnie | Yes | | Daffy | Yes | | Minnie / Goofy | No | | Donald | Yes |

In Excel, how can I make this that each name has its own row but maintains the Yes/No values from the adjacent column? I want my final table to look like this: | Owner | Alone? | | Mickey | Yes | | Goofy | Yes | | Pluto | Yes | | Pluto | No | | Mickey | No | | Minnie | Yes | | Daffy | Yes | | Minnie | No | | Goofy | No | | Donald | Yes |