spreadsheet to DB

[REBBROWN]

hey all,
I am having a 'time' trying to figure this out.
I m trying to convert a series of spreadsheets into a DB.
Please see attached spreadsheet.
They will start out choosing a SERN or Serial number and that has one to many relationship with item.
At most it might be one SERN's for tow Items but that's not the issue.
It then goes into a classification: O6, O5, E9, etc.
You see those at the top.
you could have 1 digit for say O6 (highlighted in yellow) and then at the bottom the associated cost for that column. ($223,578.62).
But look at the E6 column, also highlighted in yellow and it has more.
The only thing I can think of is to 'feed' or actually pull the SERN and ITEM into a separate table with look-ups with them being the first two fields.
Then create a field for each column name, O6, O5, O4, E9, etc.
The problem is that associated cost at the bottom.


For my O6 column highlighted in Yellow this is no problem as the associated costs is associated only with O6, and in one cell, for ITEM 10.
But go back over to E6, I can't associated the cost one time for 4, 6, 2 and 2.
Any ideas on this?

[orange]

I think you need to sort out exactly what an Item, SERN and Classification actually are. Then determine how these things are related.
eg

a SERN or Serial number and that has one to many relationship with item

You may get some ideas from data models at
http://www.databaseanswers.org/data_...all_models.htm

Good luck