Pivot tables are an excellent way of organising large amounts of data, customised to suit your present needs. The pivot table layout is a little different in Excel 2007, but you'll soon find it has really improved and pivot tables are easier to use than ever before. Example from John Walkenbach's Excel 2007 Bible.
I'll include specific written instructions at a later time. For now, the best way to show you just how pivot tables are created is via the above video demonstration.