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?