I posted this yesterday with an incorrect title so I will try again...

I am trying to create an excel file/pivot table. I receive weekly data on my customers number of sales through a corporate program that I export into excel. What I would like to do is - after exporting into excel select my top 20 customers and their sales numbers for that week; the next week I get company data I will want to do the same thing and compare side by side that weeks data to the previous weeks data so that I can identify trending.

Is a pivot table the best method for this? I have never created one before can someone help me?

Thanks so much

Tamaraz