title: Excel macro to transpose data from one sheet to another based column name and cell content
body: <p>I have a worksheet1 with a column labeled participant and columns labeled 1-20 (experiment ID numbers). </p>
  
  <p>I have another worksheet2 with data of participants (column) and the experiments (column) they participated in. In the cells under the experiment column, there are multiple experiment ID numbers as participants have participated in multiple experiments. For example a cell could read, "1,4,5".</p>
  
  <p>What I need to do is place an "X", on worksheet1, in the corresponding cells from worksheet2. For example, a cell reading "1,4,5" for participant "003" from worksheet2 would place an "X" in the columns labelled 1, 4, 5 in worksheet1.</p>
  
  <p>I hope this is clear. I am completely new to macros but need help with this as soon as possible.  </p>