TonyEF
asked on
Reverse Data
Folks I have a table in an access database that I need create a new table with that data.
Attached is a spreadsheet with two tabs, the first one is a sample of what the table looks like and the second tab is what I like the new table to look like...
Any assistance is appreciate...
Example-Data.xlsx
Attached is a spreadsheet with two tabs, the first one is a sample of what the table looks like and the second tab is what I like the new table to look like...
Any assistance is appreciate...
Example-Data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Save your query as a Query1. Create a new query as a "select * from Query1". Save it as Query2. Open Query Designer for Query2. In the Query Type select "Make table" You will be asked to type a new table name. Run the query2 (there is a button "Run")
ASKER
Excellent, thank you for your assistance....
ASKER