Hi,

I've inherited a poorly designed database and I'm hoping you can help me solve a problem.

I have data that is organized similar the following (the actual data set is much larger).

Name ID1 ID2 ID3 ID4
--------------------------------------------
Dave D1 D2 D3 D4
Tammy T1 T2 T3 T4
Merrick M1 M2 M2 M4
...