pivot table data not consolidating

[DavidH]

Hi All,

I have a pivot table that has a row field for each vendor and a column field for each month (Jan, Feb & March). The pivot table is showing one row for the March total and a second row for the Jan & Feb totals:

Vendor......Jan.....Feb.....Mar
Smith.......................300
Smith.......100.....200........

What I really want to see is one line for each vendor. I've adjusted everything I can think of, sort orders, etc. to no avail.

Any suggestions?

Thanks in advance,

DavidH

[jfuoti]

Why don't you double check your data. Smith may inadvertantly have leading or trailing spaces or be spelled differently in Mar which would cause Excel to think they are different and put them on different lines

[DavidH]

Thanks, it was a trailing space; thought I had checked that, but I missed.

Thanks again for the help!

David