Categorise data in Excel

Hi all,   I try to map the category in the right hand side of the below picture into the data table on the left. I only need to map one category for each receipt number and there is also a "Both" c...