I am trying to merge 2 dataframes and have multiple matches append horizontally:

dataset1:

```
id
1 email1
1 email1b
2 email2
3 email3

```

dataset2:

```
id name
1 bob
2 rob
3 kat

```

I would like to use merge to combine these dataframes on id. When there are duplicate matches with id 1, I would like merge by "id" to return both results horizontally:

```
id name email 
1 bob email1 email1b
2 rob email2
3 kat email3

```

It doesn't seem like merge can do this, it creates multiple rows for duplicate values. Any other ideas?