I am trying to manipulate data from 2 reports into one sheet.

The first report is a flat file with a unique record key. The second file
is a complicated disaster. It looks like the following:

Record Number A Apples
Record Number A Oranges
Record Number B Apples
Record Number B Peaches
Record Number C Bananas

I need it to look like:

Apples Bananas Oranges Peaches
Record Number A X X
Record Number B X X
Record Number C X

Is there a fancy formula that could help me? I can do a vlookup and pull it
in, that doesn't work for the multiple records for each record number. I
think my brain is fried€¦

Thanks!!!