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