convert rows into columns

From: Nikhil (anonymous_at_discussions.microsoft.com)
Date: 05/13/04 

Date: Wed, 12 May 2004 21:11:02 -0700

i have a table which gives me a list of months as records...
ie..columnname : month
row1: jan
row2: feb
row 3: mar

and so on..
i want to make a column..where these months appear as column name

ie...column1: jan
     column2: feb
    column3: mar

also...what i want is if in the first table...any month is added as a row.... the second table should also take the new month as a new column....

let me know asap

regards

Nikhil

Relevant Pages