title: How can I create 3 fields (columns) from 15 columns
body: <p>I have some data that I need to clean and parse out. The top half is the &quot;original data&quot; and the lower half is what I need the end result to look like. There could be up to 200 to 300 rows of names of the same data(top half)</p>
  <ul>
  <li>I would copy this &quot;original data&quot; into one tab every day.</li>
  <li>Run the  macro, that will create a NEW tab with the 3 cleaned columns.</li>
  <li>Next day, Copy next days data to the original data tab.</li>
  <li>Run macro and have the data append the new day at the end of yesterday.
  Ultimately, creating a excel sheet with all the days added for each person.</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/3Ml8m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3Ml8m.png" alt="enter image description here" /></a></p>