Data sorting a crosstab table
 

Hello,

I have a worksheet that is the result of a crosstab data export from a
database. The data is layed out so that the sample name
("SamplePoint") is in column A, the data source ("Source") is in
column B, the date is in coulmn C, and the variables are in columns
D:H. (but the number of variables can vary) I would like be able to
sort into a more suitable layout.

I have an example of how the original data may look like at:

http://www.niveus75.plus.com/example1.xls (see the "Original"
worksheet)


I would like to create a macro that would sort the data so that it it
places all the data in one row for a particular SamplePoint and Date,
ignoring what is in the column 'Source', so that the layout would be
thus:
http://www.niveus75.plus.com/example1.xls (see the "Final Result"
worksheet.


Any ideas how to do this?


An example of the true spreadsheet I am working one is at

http://www.niveus75.plus.com/example2.xls

Thanks

Michael