title: Excel macro? formula? for duplicate lines
body: <p>I have an excel file with patient ID entries and date of blood draw and which tubes were drawn on that date. The way it's currently set up, there's a new line entry for each date (regardless of whether the patient already exists). </p>
  
  <p>How can I easily "transpose" (correct word) the spreadsheet so that there is only one line per unique patient and the multiple dates are converted into additional columns instead of duplicate records?</p>