pivot table issue

[natey]

please hel

column a = range of dates or code word
column b = codes (often repeating in reference to different dates & codes in column a
column c = qt

i make a pivot table wher
column b becomes the row valu
column a becomes the column valu
& column c becomes the data valu

the problem is that the resulting pivot table puts items with the same column b value but differend column a values on seperate lines rather than putting them on the same line with different row values in the data field
any help would be appreciated
wish i could send an attachment here --- would obviously be easier to show

 

[Dave Peterson]

My guess is that the values look the same, but are different--maybe leading,
trailing, or embedded spaces.