after finding duplicates, how to update row?

[bbbeng]

Hoping I am overlooking a simple way to do this ...



I have a large employee table that is appended through 6 queries. After all of the append queries are run, there are tons of duplicate rows.

I want the duplicate rows to be condensed into one row per employee.

The table structure is
SSN
ID1 (text)
ID2 (text)
ID3 (text)
ID4 (text)
ID5 (text)
ID6 (text)

When all of the rows are appended, I end up with employees with multiple rows -- but one row has a value for ID1, one row has a value for ID2 and another row has a value for ID3, etc. There isnt a common business rule to indicate when a certain employee would have multiple rows so I cant make the SSN a primary key and have the append reject the duplicate rows.

Can anyone think of a way to 'group' the employee rows so they become 1 row with all of the data on one row?

Thank you so much for your insight!

[June7]

Your sample shows SSN as field name but the data does not show repetition.

You want to rearrange data to horizontal (left to right) display, essentially de-normalizing data.

Review https://www.accessforums.net/showthr...rows-to-column