Conditionally merge rows to columns

[Pasch]

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.

[Adaptable]

Assuming this is a one-off spreadsheet tidy up exercise, it can be done relatively simply:
With the ranges of your image and assuming that (as in your picture) repeat names follow in subsequent rows (if they don't I'd recommend sorting, both so below will work, and because it will make checking easier if repeat names are together):
D2 formula: =IFERROR(VLOOKUP(A2,OFFSET(A2,1,0):OFFSET(C2,6,0),2,FALSE),"")
(looks up in a range starting in column A in the row below to column C row 6 (substitute your last row with data) for value in column B). Fill down.
E2 formula: =IFERROR(VLOOKUP(A2,OFFSET(A2,1,0):OFFSET(C2,6,0),3,FALSE),"")
(looks up in a range starting in column A in the row below to column C row 6 (substitute your last row with data) for value in column C). Fill down.
F2 formula: =IFERROR(VLOOKUP(A2,OFFSET(A2,2,0):OFFSET(C2,6,0),2,FALSE),"")
(as for the second car but offsets two rows). Fill down.
G2 formula: =IFERROR(VLOOKUP(A2,OFFSET(A2,2,0):OFFSET(C2,6,0),3,FALSE),"")
(as for second car but offsets two rows). Fill down.
Convert to values once checked then remove duplicates (select full range, data, remove duplicates, selecting only column A).

I am sure it can be done more elegantly, but assuming this doesn't have to be done again and again, this will do the trick.

[Pasch]

Hi Adaptable,

thanks for your help! Sounds like a good approach, I couldn't make it work though. Maybe a version issue, I'll keep on trying