General :: Denormalizing Data For Easy Analysis In Excel

I have a quality control database that has a QCEntry table that contains information about each sample the QC technician takes from production. This table has a one to many relationship with the TestResults table, where the tests performed on the sample and their results are stored.

QCEntry table is structured like

Code:
EntryID Product Lot Number Day Time
1 AB-500 121323 12/23 5:00

TestResults table is like

Code:
ResultID Entry ID TestName TestResult
1 1 Carbonblack 50
2 1 MFI 10

My question is: Is there a way modify large amounts of data like this using a query or some other method to look like this? Kind of denormalizing the tables?

Code:
Product Lot Number Day Time Carbonblack MFI
AB-500 12323 12/23 5:00 50 10