hello...hope someone can help me here
I'm creating a pivot table on the data below
Date County Number
01/01 Armagh 1
01/01 Armagh 1
01/01 Armagh 1
01/01 Down 2
01/01 Down 2
02/01 Armagh 3
02/01 Armagh 3
I want the pivot table to look like this below with the number in the middle, however line 1,2 and 3 above are duplciates and i only want them included once, same with line 4 and 5...can this be done?
County
Date
I'm creating a pivot table on the data below
Date County Number
01/01 Armagh 1
01/01 Armagh 1
01/01 Armagh 1
01/01 Down 2
01/01 Down 2
02/01 Armagh 3
02/01 Armagh 3
I want the pivot table to look like this below with the number in the middle, however line 1,2 and 3 above are duplciates and i only want them included once, same with line 4 and 5...can this be done?
County
Date