Spinning rows into columns, in a view. Is it possible?

[Bryce Nesbitt]

I have some tables in SQL, with rows that represent a measurement for a location, at a particular date:

location date value
1 jan 103
2 jan 123
1 feb 861
4 feb 69

I would like to offer a "view" into this table, for spreadsheet users, via ODBC. Is there a way to automatically reformat data in this view, so spreadsheet users can easily plot it?

Something like:

--- #1 #2 #3 #4
jan 103 123 99 33
feb 861 511 6 69