Convert Record Data to multiple field data in one record.
I inherited a table where each specification for a Part Number was given an individual record. I want to create a table where there is one record for each Part Number and many fields in that record would contain the many specifications for the part.
Attached is the structure of the original table.
My first attempt was to create a new table with a relationship on part number. I need help coming up with a calculation to extract the specifications from multiple records to multiple fields.