DSXchange

I have a file that looks like this : 1,Andrew 1,Beer 1,USA 2,Nadine 2,Mark 2,UK 3,Bian 3,Mendez 3,USA I want to transform to merge rows with the same number to a single row so that the file would look like this: Andrew,Beer,USA Nadine,Mark,UK Bian,Mendez,USA What stage should I use ?