Combine rows with duplicate values into separate columns

I'm trying merge rows that contain similar data using the easiest method possible, but i assume it will require some VBA. If anybody is able to point me in the right direction that would be great.

An example of what i'm trying to achieve is:

Please Login or Register  to view this content.

Turned into:

Please Login or Register  to view this content.

EDIT: I've managed to pile together what i need, however it seems to place the non duplicate data into the same column separated by a ";" as opposed to my preferred Name 1 | Name 2 | Name 3 any thoughts on updating this to populate separate cells rather than the same? It also only seems to use logic on two columns as opposed to three i'm requiring.

Here is the update:

Please Login or Register  to view this content.

Try adding:

Please Login or Register  to view this content.

to the end

This is awesome! Thank you very much. Only problem is it seems to leave a empty column before and after the 2nd column (aka 'AGE'). Is there anyway to remove these?

you can delete a column with:
columns(1).delete
columns(3).delete

Hi - I think the code already matches both columns.

I'd suggest putting in column D:
=B2&C2
and then copying down and matching by this column. for example:

Please Login or Register  to view this content.

Seems to work after some playing around, but it hates being moved around. For example if i try to add another column like below, it just go's mental. Is there away to keep this function purely inside VBA? As i also need to run the code multiple times.

Here is the changes i tried to make to add another fourth column:

Please Login or Register  to view this content.