Below is a regular table then a pivot table. The pivot table has the retailer column that has the sum of Price per Unit column as well as the Sum of Units Sold.
There is a duplicate row of a president (showing below), I'm going to remove it by selecting the DATA menu and then selecting the Remove Duplicates icon.