title: Populating Gridview from SQL table with different formats
body: <p>I created a SQL table to populate various gridviews using boundfields with the following column format:<br>
  <strong>[Line], [Indicators], [YTD], [Jan], [Feb], ..., [Dec]</strong><br>
  The first two columns of my table are variables, 'YTD' and the months contain the data.</p>
  
  <p>I need to create a new gridview with a general format of:<br>
  <strong>[Line], [Indicator 1], [Indicator 2], ... , [Indicator k]</strong><br>
  Each distinct 'indicator' needs to be shown against its corresponding 'line' where the month is, for example, Jan.  I'll query and bind the table whenever a different month is chosen to display.  </p>
  
  <p>The goal is to avoid creating a new SQL table, but I'm not sure if selecting the data in this format is feasible with 1 query.  Any ideas would be appreciated.</p>