Pivot View

[C# Programming]

hi guy i have pretty simple requirement
i have three rows in my table

year ----amount
2011-----100
2012-----200
2013------400


now what i want is to show these rows in columns lets say as i have three distinct years
so i want to create three columns ar run time and these columns should be

2011--------2012----------2013
100--------200------------400

any ideae how to achieve this?
is this a pivot view ?
regard.

Tauseef A Khan
MCP Dotnet framework 2.0.