Using SQL to shape chart data

Hi,
I have read the manual at here, but still could not resolve my problem.

My original table - monthly_subtotal has four columns: ID, Grant,Subtotal,Month. Its structure and data are shown on left in the picture. From this table, I need to make a chart like the one shown above (bottom-right). To achieve this, my idea is to make a new table from the original one, and by using SQL query, re-shape the table structure so that it looks like the one on top-right. The desired new table keeps column Month (distinct) but will use all the data values of the Grant column (distinct) in the original table as column names. These new columns take the corresponding data values of column Subtotal as their data.
Could anybody help build the SQL query? Thanks so much.