Can you Please help
Question
column1 has list of various post codes
column2 has name of the suburbs
eg
4006 Bowen Hills
4006 Herston
4006 Newstead
4006 Fortitude Valley
4007 Hamilton
4007 Ascot
4008 Pinkenba
4009 Eagle Farm
4010 Mayne
4010 Albion
4011 Eagle Junction
4011 Hendra
4011 Clayfield

can you please help me with a formula in excel which gives the result as
follow

4006 Bowen Hills, Herston ,Newstead ,Fortitude Valley
4007 Hamilton, Ascot
4008 Pinkenba
4009 Eagle Farm
4010 Mayne, Albion
4011 Eagle Junction, Hendra ,Clayfield

Thank you

varun