Ability to consolidate information that contains the same information in a table for export:

For example:

Table
Item # GL Code Location Amount
1234 5000.10 103 100.00
2345 5010.20 105 200.00
1234 4102.20 103 100.00
1234 5000.10 103 300.00

The Export would be the following:
1234 5000.10 103 400.00
2345 5010.20 105 200.00
1234 4102.20 103 100.00

As you can see, there were 2 rows that contained the same Item #, GL Code, and Location....so we combined them to 1 row for the Export and added the Total Amount.

Is this possible?