This is exactly what the end result should looks like!!

except i need to produce it dynamically. i looked at the articles, and i think Part2 (Cross tabs and pivot2- Dynamic...

yes, i need to group by Measurement_Site_desc, and display Measurement_Date in columns for upto 5 dates.

the desired result should be something like this...

desired results...

Measurement_Site_desc 8/31/20119/5/2011...

sorry, i'm newbie and this is my first time posting my question.

anyway, i updated my original post, that has the flow of creating the sample table, test data, and query...