I receive a spreadsheet that is imported into access, and it needs to be manipulated to make columns out of some of the rows, and get counts for locations.
Attached is a database that shows with two tables, the Received which is the direct spreadsheet import, and the needed which is the table that has altered the data into the format that I am needing it in.
How would I go about, either thro VBA or queries to get the data from the Received format to the Needed Format?
Attached is a database that shows with two tables, the Received which is the direct spreadsheet import, and the needed which is the table that has altered the data into the format that I am needing it in.
How would I go about, either thro VBA or queries to get the data from the Received format to the Needed Format?