Remove Duplicate, and Mapping Unique of one column to another

I’ve 2 columns on the SQL data

URL
Title

But, the issue is that there are duplicate URLs in the sheet and different titles

i.e

example.com xyzzy
example.com abac
example.com mnop
example.com pqrst
example.com vamp

Now, what I want as an outcome

example.com xyzzy
abac
mnop
pqrst
vamp

Example.com/1 title 1
title 2
title 3
title 4
title n