create a pivottable based on the range a7:g32. place the pivottable in cell i17 on the current worksheet. place payment type in the rows box and amount in the values box. format the amount with accounting number format.