title: MySQL - Split two columns into two different rows
body: <p>I don't have any idea to create this sorry if it is a silly question.</p>
  
  <p>I have a table two teams and total watch and I will use this information later a different place so my idea concat this two column in one column but two different rows:</p>
  
  <pre><code>HomeTeam      AwayTeam     Totalwatch 
  A              B              100
  A              C               90
  C              A               80
  D              B               70
  C              E               50
  </code></pre>
  
  <p>Can I this</p>
  
  <pre><code>Teams          TotalWatch
  A                100
  B                100
  A                 90
  C                 90
  C                 80
  A                 80
  D                 70
  B                 70
  C                 50
  E                 50
  </code></pre>
  
  <p>I have a few columns so they will repeat as well. </p>
  
  <p>Just a note I know how can <code>concat</code> in one-row use with <code>concat</code> function I do not know how can I make with two rows</p>