summary and sort table by indexes

i have a table with 3 columns
quantity, x, y

and im trying to make summary of rows which have same indexes in X and Y
and sort by those indexes.

I MEAN FOR EXAMPLE

QUANTITY--X---Y-------->-QUANTITY---X---Y
-----3-------A---B------->--------5------A---B
-----2-------A---A------->--------2------A---A
-----2-------A---B------------------------------
didnt manage to solve it in pivot charts

This proposed solution employs a helper column which may be hidden (or moved) for aesthetic purposes.
The initial range has been changed to a table so that it may easily be sorted and appended.
Two columns are added to the table. The first combines the X and Y values using: =[@X]&[@Y]
The second totals the quantities using: =SUMIFS([Qty],[X],[@X],[Y],[@Y])
The helper of the result table is populated using:

Formula:

Please Login or Register  to view this content.

The Qty, X and Y columns of the result table are populated using formulas similar to: =IF($H6="","",INDEX(Table1[Sumifs],MATCH($H6,Table1[[XY]:[XY]],0)))
Let us know if you have any questions.