I want to know how I can find duplicate records and append them all together in single row. I have 250,000 rows of data and use ms access 2010. For example in below table, there are two columns of record for each row. paul, blue paul, red john, purple john, pink john, white After duplicate check , I want following result. paul, blue, red john, purple, pink, white