Firstly for this example I created a time table here's the data. As you can see it's a simple table showing year,town and an amount, this is the source data which is in a table I've called "felbrigg".
Now here is what I'm trying to achieve.
And here is the pivot statement to do it. with line numbers to help explain
FROM (SELECT [year],town,amount from felbrigg) as source
for town in ([towcestor],[mk],[barley])
) as pvt
1. Is the column list in the final output
2. Is the source of data, matches my source table in this example.
5. Is the calculation that is to appear in each cell of the final results
6. This specifies the column in the source that will be turned into columns in the final result, and you have to hardcode the values you want from the source column!