With this information
Record Number A Apples
Record Number A Oranges
Record Number B Apples
Record Number B Peaches
Record Number C Bananas
.... in A1:B5; with "Apples Bananas Oranges Peaches" headers in H2:K2;
with
Record Number A
Record Number B
Record Number C in F3:F5, use this formula and copy over and down:
=IF(SUMPRODUCT(--($F3=$A$1:$A$5),--(H$2=$B$1:$B$5))=1,"X","")