ms access find duplicate query and add alais colum : i have a access db name testdb , table name table1, now table having 2 fields BinNo and Prodcode, Binno having many duplicate rows , i want to group binno whereever have dulpicate row to create new alias column 

=============================================
Binno  |  Prodcode |
============================================
Bin no1| Pro 1
Bin no1| Pro 2
Bin no1| Pro 3
Bin no2| Pro 4
Bin no2| Pro 5
================================================

should create query 
=============================================
Binno  |  Prodcode1 | Prodcode2| Prodcode3|
==============================================
Bin no1| Pro 1      | Pro 2    | Pro 3
Bin no2| Pro 4      | Pro 5
================================================

