Aggregate data based on dissimilar rows value

  • 21 September 2019
  • 0 replies

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.

0 replies

Be the first to reply!