Combine Multiple Cells Based on Unique Identifier (email address)

[BeeZeRCoX]

Good morning! We've got an event coming up where individuals could purchase multiple items where each item populated on its own row. So if someone ordered four different items, it shows on four different rows with the same email address for each row.

I'm trying to produce a printout that would combine all the different ordered items to a single cell matched by email address.

For example, the output is currently:

Column A Column B
abc123@gmail.com Item A
abc123@gmail.com Item B
abc123@gmail.com Item C

And I'd like an output that produces:

Column A Column B
abc123@gmail.com Item A, Item B, Item C

Bonus if I can also implement a 3rd column (quantity) into the final output.

Thanks in advance!

[Limor_OP]

Hi,
Are you using excel 2003?

[BeeZeRCoX]

Ah I should update my profile. Greet catch! I'm using Office 365. Thank you!

[Limor_OP]

OK

Please Try this:

C1 and down:
=IF(A2=A1,B1&","&C2,B1)

E4
=UNIQUE(A1:A9)

F4 and down:
=INDEX(C:C,MATCH(E4,A:A,0))

[BeeZeRCoX]

This looks like it'll work perfectly. Will test it out and let you know for certain - thank you so much!

[Limor_OP]

Good Luck.

[BeeZeRCoX]

Marked as solved. Thank you so, so much. Was able to work backwards from your formula and also implement the quantity column. Very clean end result! Thanks again.

[Limor_OP]

Good! You're welcome.