Hi all,

I'm not sure if this can be done in Excel or not, I don't know what to google for either, so my apologies if this can be found in this forum. I made an effort without success.

So, problem is simple. I have a column A which contains names, there can be several rows with the same name, columns B-C containing different things then.

Skärmdump 2014-09-12 10.13.42.png

The goal is to collect all of the same name and merge them to one row only. Can this be done?

Skärmdump 2014-09-12 10.16.25.png

Many thanks in advance.