I have data Month/Location/Value that I need to transpose into
Location / month1 / month2 / month3 / month4
I have used pivot in a Stored Procedure in the past but am having difficulties with it at this time.
Can it be easily transposed in webgrid?
Yes, that is what I am after. I am on a sql 2000 machine doing the last 13 months dynamically which has made that more difficult.
If by "transpose" you mean "turn columns into rows and rows into columns," you should do this at the data source or database level.