title: SQL SELECT Multiple Columns Into Merge into 1
body: <p>I do NOT want to concatenate anything. Instead, given a table which has <strong>multiple columns</strong>, I want a <code>SELECT</code> statement which will then return each of those columns as if they existed in different rows (<strong>ONE COLUMN</strong>). Example...</p>
  
  <pre>
  TABLE                         
  +--------+---------+---------+                             +--------+
  |Person1 | Person2 | Person3 |                             |Person  |
  +========+=========+=========+   SELECT *ANSWER HERE*      +========+
  |Alex    | Ben     | Charlie |   FROM PEOPLE               |Alex    |
  +--------+---------+---------+   ORDER BY *person*?        +--------+
  |Dale    | Eric    | Gary    |                             |Ben     |
  +--------+---------+---------+   RETURNS ------------>     +--------+
                                                             |Charlie |
   ^^^ NOTE ABOVE HOW WE ^^^                                 +--------+
      HAVE THREE COLUMNS                                     |Dale    |
                                                             +--------+
                                                             |Eric    |
                         NOTE HOW WE ONLY                    +--------+
                         RETURN ONE COLUMN -------------->   |Gary    |
                                                             +--------+         </pre>
  
  <p>Notice: we start with a table that has <strong>three columns</strong> and are now returning a result as if each row were independent.</p>