title: Record columns to rows in grid C# Winforms
body: <p>First off I'm not a programmer. I do know the basic stuff and have done website coding. This is quite a bit different obviously and it's something I haven't actually encountered before.</p>
  <p>This might not be the place to ask this question, so please feel free to let me know.</p>
  <p>Here's the link to SQL Fiddle that I created with a &quot;sample&quot; of the table. Obviously I've left out many columns because there is quite a lot of them. Balances etc and so forth for each account.</p>
  <p><a href="http://sqlfiddle.com/#!9/89db50/1/0" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/89db50/1/0</a></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">AccNumber</th>
  <th style="text-align: center;">AccDesc</th>
  <th style="text-align: center;">BudgetThis01</th>
  <th style="text-align: center;">BudgetThis02</th>
  <th style="text-align: center;">BudgetThis03</th>
  <th style="text-align: center;">BudgetThis04</th>
  <th style="text-align: center;">BudgetThis05</th>
  <th style="text-align: center;">BudgetThis06</th>
  <th style="text-align: center;">BudgetThis07</th>
  <th style="text-align: center;">BudgetThis08</th>
  <th style="text-align: center;">BudgetThis09</th>
  <th style="text-align: center;">BudgetThis10</th>
  <th style="text-align: center;">BudgetThis11</th>
  <th style="text-align: center;">BudgetThis12</th>
  <th style="text-align: right;">BudgetThis13</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">2000000</td>
  <td style="text-align: center;">Test Account</td>
  <td style="text-align: center;">15</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">20</td>
  <td style="text-align: center;">19.5</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">14</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: right;">0</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'm creating an app using C# and Winforms. I'd like to display a gridview where the table columns are &quot;unpivoted&quot; to rows. Since there is additional columns to my example that's not included, I need to be able to specify the table column names since I don't need ALL the columns in the table to be rows. Creating a view works but the problem with that is that I need to be able to edit the unpivoted columns data and update it in the example table.</p>
  <p>What I need the grid to look like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Per</th>
  <th style="text-align: center;">Budget This Year</th>
  <th style="text-align: right;">Other Columns to follow</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">BudgetThis01</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: center;">BudgetThis02</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">BudgetThis03</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: center;">BudgetThis04</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  <tr>
  <td style="text-align: left;">5</td>
  <td style="text-align: center;">BudgetThis05</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  <tr>
  <td style="text-align: left;">6</td>
  <td style="text-align: center;">BudgetThis06</td>
  <td style="text-align: right;">0.00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'm truly lost with how to achieve this in the best way.</p>
  <p>Your guidance in the right direction would greatly be appreciated.</p>