I am creating a pivot from a database of 7500 transactions spanning 13 months. The row labels are GL account #s . The column labels are Year/Month. I am getting GL #s listed twice. I have tried reformatting cells in the database, making all transactions left-justified, and copying/pasting values and number formats so all transactions with those GL #s are the same. How can I get the row labels to show once and and include all the transactions for that GL #? Thank you.
Here is a partial screen shot. 103840, 112900 & 209200 are listed twice and have transaction amounts in both rows:
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Here is a partial screen shot. 103840, 112900 & 209200 are listed twice and have transaction amounts in both rows:
Sum of FIN.TRANSACTION AMOUNT | ||||
FIN.ACCOUNTING CODE 06 VALUE | 201704 | 201705 | 201706 | 201707 |
103840 | 1,554.63 | 2,292.59 | ||
112900 | 2,853.42 | 105.44 | ||
209200 | ||||
103820 | ||||
103830 | 6,751.49 | 6,136.50 | 10,324.02 | 4,616.95 |
103840 | 1,162.01 | 4,407.45 | 1,531.98 | 3,110.00 |
107900 | ||||
112900 | 1,096.30 | 82.08 | 3,431.27 | 3,731.62 |
202450 | ||||
206200 | 19.99 | 50.00 | 50.00 | |
208400 | 49.23 | |||
209200 | 9,619.69 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>