Wednesday, March 7, 2012

convert rows into columns

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
MSKB (support.microsoft.com) article : 175574
Anith

No comments:

Post a Comment