Data Example Current vs. Desired Format.jpg
Trying to re-orient the data in excel worksheets so that I can import data into MSACCESS and run simple queries against data.
See pic attached. Can this be accomplished via pivot table?
Data Example Current vs. Desired Format.jpg
Trying to re-orient the data in excel worksheets so that I can import data into MSACCESS and run simple queries against data.
See pic attached. Can this be accomplished via pivot table?
Yes, check out the solution here:
https://michiel.wordpress.com/2009/0...bles-to-lists/
Scroll down to "An even quicker solution" and follow the steps.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks