title: MS Access 2007: Using SQL to Transpose rows to columns
body: <p>SQL newbie here. I have table setup as the following (my apologies for the poor formatting):</p>
  
  <p>Cycle ID....UBCI....chemo_cycle....csf....rsn_no_csf
  <br/>
  57.............18001...1......................N.......N  <br/>58.............18001...2......................N.......N<br/>59.............22002...1......................Y........null</p>
  
  <p>I'd like to convert it into the following format:</p>
  
  <p>UBCI....chemo_cycle1....chemo_cycle2....csf1....csf2....rsn_no_csf1....rsn_no_csf2  <br/>18001...1.........................2.........................N........N........N.....................N<br/>22002...1.........................null......................Y........null.....null..................null</p>
  
  <p>There can be up to 26 chemo_cycles per UBCI. I tried some of the other suggestions, but wasn't familiar enough with SQL to work out some of the finer details. Again, apologies for the formatting. Any help would be appreciated.</p>
  
  <p>Thank you!</p>
  
  <p>-Omar</p>