Informatica : Interview Question -- Tranpose Rows To Columns

Input --- 1 Mandar 1 Raghunath 1 Gogate 2 Sudhir 2 Taksale 3 Ashish 3 Jaiswal 4 Sakshi 4 Gakhar Output -- 1 Mandar, Raghunath, Gogate 2 Sudhir, Taksale 3 Ashish Jaiswal 4 Sakshi Gakhar