excel
 

Column A contains Postcodes numbers, Column B contains Suburbs
I would like a formula where Column C contain combined list of of suburbs in
a particular Post code separted by comma
for example row1- PC 4034 suburb Geebung,
Row2- 4034 Aspley,Row3 - 4034 Zillmere

Answer required - Post code 4034 - Geebung, Aspley,Zillmere

need ur help

thanks

varun