Hi,

I need some help. I am trying to filter the data by unique value in the column and copy paste it to the different sheet like a groups.

ex:- I have data like this

Item1 Item2 Sales
Group1 1 $10
Group1 2 $20
Group1 3 $20
Group2 1 $20
Group2 1 $30
Group3 1 $10
Group3 1 $15

I want the data should look like this

Group 1

Item2 Sales
1 $10
2 $20
3 $20

Group 2

Item2 Sales
1 $20
1 $30

Group 3
Item2 Sales
1 $10
1 $15

Please help me how can we do that.