title: Loops through Access Table and for each Column with Data
body: <p>I think this should be simple, but I can't find the right way to do it. I have a table with an ID number column, and 10 rows following it labeled Question #1, Question #2, and so forth. </p>
  
  <p>There are no duplicate ID numbers, but each ID number could have more than one row of questions.</p>
  
  <p>I would like to take the ID row and for each different question where applicable create a new row with the same ID.  So if an ID number has a question listed under the Question #1 and Question #2, Id like to create a duplicate for that ID number and have have both questions listed under one column Lets call it "Total Questions", and grouped by that ID number.  This can be done by creating a new table.</p>
  
  <p>Example:</p>
  
  <p><strong>From:</strong> </p>
  
  <pre><code>+-------+---------------------------+---------------------------+
  |  ID   |        Question #1        |        Question #2        |
  +-------+---------------------------+---------------------------+
  | 11111 | Was it notated correctly? | Was it completed on time? |
  +-------+---------------------------+---------------------------+
  </code></pre>
  
  <p><strong>To:</strong></p>
  
  <pre><code>+-------+-------------------------------------+
  |  ID   | Total Questions                     |
  +-------+-------------------------------------+
  | 11111 | Was it notated correctly?           |
  | 11111 | Was it completed on time?           |
  +-------+-------------------------------------+
  </code></pre>