View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rob B
 
Posts: n/a
Default duplicated data in pivot table

To illustrate what I mean, here is a selection from the offending fields:


1997 4051 7394 1718 100
1998 1101 6432 600 250
1999 5965 9551 474 150
2000 5755 5377 1225 256
2001 3508 3225 604 632
2002 4483 3381 101
2003 5659 6410 990 1327
2004 9118 3588 1383 1375
2005 26024 4827 359 945
1989 1500
1990 1500
1992
1993
1994
1995
1996
1998
1999
2000 30
2001 775
2002 780
2003 750
2004 880
2005 150
(blank) 0 2969 548 106
Where the entries after 1989 -1500 appear to be left justified whereas all
those above are right justifed. The source feild has been reformatted 3 times
and is text based.

Please help!