I have imported data from two spreadsheets into an Access database. The first table is a list of manufactured parts; each record has a unique part number, a brief description, and additional fields with information on the costs involved in making the part in question.
The second table has a list of materials and supplies used to make different parts. In this table a part number can appear in several adjacent records. There is a field for describing the material or supply used, another for a number to ID the material or supply in question, and a column for the cost.
I need to transpose the data columns into rows, especially the cost column, so the data can be matched with the rows in the first table. Can anybody recommend a good way to do this? The spreadsheets are too big for me to transpose the data in Excel.
Thank you in advance.
The second table has a list of materials and supplies used to make different parts. In this table a part number can appear in several adjacent records. There is a field for describing the material or supply used, another for a number to ID the material or supply in question, and a column for the cost.
I need to transpose the data columns into rows, especially the cost column, so the data can be matched with the rows in the first table. Can anybody recommend a good way to do this? The spreadsheets are too big for me to transpose the data in Excel.
Thank you in advance.
