title: I want to transpose a loop of 5 columns and 100 rows into 1 row
body: <p>I have 5 columns and 100 rows of information I need to put into a single horizontal row.</p>
  
  <p>for example:</p>
  
  <p>red   green   blue  yellow
  red   green   blue  yellow
  red   green   blue  yellow
  ect...</p>
  
  <p>to</p>
  
  <p>red   green   blue  yellow red   green   blue  yellow red   green   blue  yellow...ect</p>
  
  <p>please help I have no idea how to create a macro so be as basic as possible! thank you</p>