Remove duplicates from column 1 and concatenate column 2 - is this possible?

[Really Simple]

Hello.
My issue is that I have 1200+ addresses to make more readable - the first column is the street name, the second is the post code(s) relative to the street - what Ideally I'd like to achieve is one row per street, the street name followed by the post codes... i.e. take this...

A33 Relief Road RG2 0RR
Abbey Square RG1 3AG
Abbey Square RG1 3BE
Abbey Square RG1 3BQ
Abbey Square RG1 3FB
Abbey Street RG1 3AN
Abbey Street RG1 3BA
Abbey Street RG1 3BD
Abbots Walk RG1 3HW
Aberford Close RG30 2NX
Admirals Court RG1 6SP
Admirals Court RG1 6SR
Admirals Court RG1 6SS
Admirals Court RG1 6SW
Ainsdale Crescent RG30 3NG
Alan Place RG30 3BW
Albany Road RG30 2UL

to this...

A33 Relief Road RG2 0RR
Abbey Square RG1 3AG, RG1 3BE, RG1 3BQRG1 3FB
Abbey Street RG1 3AN, RG1 3BA, RG1 3BD
Abbots Walk RG1 3HW
Aberford Close RG30 2NX
Admirals Court RG1 6SP, RG1 6SR, RG1 6SS, RG1 6SW
Ainsdale Crescent RG30 3NG
Alan Place RG30 3BW
Albany Road RG30 2UL

Any and all help would be most gratefully received!

[poptcorn]

I have a user defined function (VBA-based function) that I found this week that should do what you are looking for, posted below:

Please Login or Register  to view this content.

Find unique street texts by going to Data -> Remove Duplicates, then use the UDF to find each post code associated.

To add UDF:
1) alt+f11 to open visual basic
2) insert->module
3) Paste code
4) Close Visual Basic

To run, just type =lookupconcat(

The first variable is the one you are referencing i.e. a single street_text
Second variable is the column you are referencing from (your column A)
Third variable is return column (column B)
Fourth variable is the delimiter, i.e. what goes between the returned results. Use CHAR(10) to return in a paragraph with each postcode separated by a line break, or use " " to put a space between results.
Fifth Variable = TRUE (match the whole cell you are referencing, i.e. full street name)
Sixth Variable = TRUE (uniques only)

The code is referenced within. Click the link for more details.

[Really Simple]

POPTCORN - Many thanks. Where and when do I type "=lookupconcat(" should all the cells be selected? Sorry but Excel is still a dark art to me...

[poptcorn]

Just type it in a cell just like you would a normal function (e.g. =sum() ). The first variable should be the street for which you are looking for all the post codes, the second variable should be the list of streets, the third variable should be the full column of postcodes.

Does that make sense? Did you manage to add the UDF?

[poptcorn]

I have attached the solved file - keep in my that you might want to turn excel auto-calculation off because this UDF may slow down

Let me know if this works

[Really Simple]

POPTCORN - Many thanks, I was offline and didn't get chance to thank you in a timely manner!