reorganizing data from pivot table format to a format more suitable for presentations

[pwent_1975@yahoo.com]

I have data laid out in a format suitable for pivot tables. I have been asked to present the data differently and need help with the appropriate function to extract the data into a different table.
Data are currently formatted this way:

Client Sample ID_ Collection Date Analyte Result Units
CC Grab 2/21/2013 BOD 52 mg/L
CC Grab 12/7/2011 Copper 0.02 mg/L
CC Grab 12/13/2011 Copper 0.05 mg/L
CC Grab 12/21/2011 Copper 0.03 mg/L
CC Grab 1/12/2012 Copper 0.06 mg/L
CC Grab 1/25/2012 Copper 0.01 mg/L
CC Grab 2/15/2012 Copper 1.80 mg/L

I need to reformat to look like this:
Client Sample ID_
Analyte Analyte Analyte Analyte Analyte Analyte Analyte
BOD TSS TDS Cu D. Cu Zn D. Zn
Units Units Units Units Units Units Units
Collection date Result Result Result Result Result Result Result
Collection date Result Result Result Result Result Result Result
Collection date Result Result Result Result Result Result Result
Collection date Result Result Result Result Result Result Result
Collection date Result Result Result Result Result Result Result


I have attached a SS with the before data in DATA tab and the after data in the Sorted Data tab.