I dont know where you are trying to go with all of this, but I would probably use a pivot table linked to the original data.