Pages

Search

Excel Help Forum - Excel General: Consolidate rows with duplicate ID number into one row

Feed2Mail notification - new post on Excel Help Forum - Excel General
Consolidate rows with duplicate ID number into one row
Hi everyone. I had a question that's been bugging me for a bit. If there are duplicates of an ID number in my database, how do I consolidate these into a single row and delete the duplicate? This is best illustrated in the example attached. What I have is on sheet one, what I need is on sheet 2....