Create a pivot tableselect the list and headingClick Data/Pivot table...accept the first two defaultschoose current worksheetclick where you want the reportdrag Products to the row source areadrag products to the data area