this might be what I am looking for . I will learn a little bit about this pivot table and hopefully do my work . thanks you all excel wizards !