title: MySQL: Combining multiple columns from Table 1 and inserting into 1 column in Table 2
body: <p>I've been trying to figure this out, but can't seem to come up with a simple solution.</p>
  
  <p>Say for instance I have a table that has similar data throughout 3 columns (i.e. different types of activities spanning 3 columns) but I want to have those three columns inserted into a separate table (Table2) so I can keep the like data together and perform a JOIN to match it with its respective data in Table1.</p>
  
  <p>I'm not talking about performing a CONCAT or CONCAT_WS, but moving those three columns from Table1 into one column in Table2, each item with its own row.</p>
  
  <p>Is there a way to do this through a query without having to manually insert each entry into Table2?</p>
  
  <p>Thank you in advance!</p>