Excel Pivot Table - providing sum
Posted on 2011-10-18
Hope you can help. I am open to using either Excel or Access but prefer Excel
Simple task but need better way to do this.
Example Data that is currently in spreadsheet
KEY Date Code1 Code2 Amount
12345 Feb10 A B 20.00
12345 Aug20 A C 10.00
12345 Aug30 A G 30.00
12222 Feb20 C A 20.00
12222 Mar20 C B 55.00
12222 Jul10 B C 40.00
I need to end up with
12345 dontcare dontcare dontcare 60.00
12222 dontcare dontcare dontcare 105.00
In the dontcare columns I am saying that I dontcare which row the value is kept from - and it can be random, it doesn't matter.
I that stated clear enough? I think I can use Pivot Table to do this but can't quite get it.