select relevant data and transpose

I have to sort data every so often and the manner in which i download it isn't very useful. It would be much more useful and muc much easier to read if the data were set out in a completely different way.

How can i organise the data so that it will create a sheet that has the column headers of: site name, date, det1, det2, det3 (etc for all dets, over 100)

and under each column to have the site name with the relating date and data for each of the dets relating to that date and site. It would be useful to only get one row of data for each date for that particular site, so that you can view all of the data for that entry in one go.

I have attatched a sample spreadsheet with only a few sites, there a re normally around 300 sites (each with over 100 dets)

I am using office 2003

I pivot table would be nice to view the data, but this data needs to be added to another spreadsheet where data for the last few years is kept.

So this has to be done fairly frequently.

Do you think it is possible to re-arrange the data in a macro so that there is only 1 row for each site and date?

I had help earlier on how to get the correct result using formlua (http://www.excelforum.com/excel-gene...nd-filter.html), but this would be time consuming for the future, wondered if I could use a macro as once made it could be used everytime data is downloaded.