Duplicate row labels in pivot table- Excel 2013

[Garry T]

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:

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>

 

[04nimmot]

my instant instinct would be try trimming the GL codes. Literally select all of the GL Codes then Find and Replace a blank space with nothing, alternatively insert a column use the formula TRIM() and paste values back over the original. Usually the cause.

 

[Garry T]

my instant instinct would be try trimming the GL codes. Literally select all of the GL Codes then Find and Replace a blank space with nothing, alternatively insert a column use the formula TRIM() and paste values back over the original. Usually the cause.

Thank you. This didn't work but it did help. I was previously unfamiliar with TRIM. I solved by pasting the left-justified #s off the pivot to a new column to the right of my database. I then created a new GL column with VLOOKUP using the pasted #s as the array. Then I recreated the pivot and keyed off my new GL column.

I often solve a problem just by bouncing it off another person, so I really appreciate your help with this.
By the way when I tried find/replace with blanks, it wouldn't execute the command.

 

[04nimmot]

As long as you got there, all is good. Strange about the find and replace, in the find you have to press space bar once and that's all. Weird it didn't work hey ho hum