Ok, Here is what I'm trying to do.



I have a spreadsheet (Link Below) that has RD-titles in Column A from row 2 down.

In row 1 for column B-EM are PD numbers.

Colums B-EM are the RD_numbers that were assigned for the titles starting at row 2and down.

So each of the RD-titles that are assigned to a PD# gets a number that is listed in the column/cell for each.

So if looking at the spread sheet PD 341 currently has two titles associated and their numbers are RA-146-4 and SA-015-3. And PD 393 has 6 titles associated with their numbers as RA10, RA11, RA27, RA26, RA02, RA07.

How can I create the table design that would allow easy data entry.

I have added a sample of the excell file to https://secure.filesanywhere.com/fs/v.aspx?...789606275b0aaa3