Aggregate data based on dissimilar rows value

Is there any way to aggregates sales and other columns based on dissimilar rows values. I have one column that has different rows values


for example:


Product name state Sales1 Sales 2


AA 1 CA 12 11


AA 2 AL 11 15


AA 3 NY 13 25


I want to group the three Product name and give it a name as AA and see the pivoted sales. and keep the state and other column as it is.