title: UNPIVOT mysql data to other table
body: <p>Hi i have the following mysql data </p>
  
  <pre><code>INSERT INTO `monthly` (`id`, `year`, `stat_id`, `cat_id`, `January`, `February`, `March`, `April`, `May`, `June`, `July`, `August`, `September`, `October`, `November`, `December`) VALUES
  (1, '2017', '12', '25', '1', '3', '1', '1', '3', '4', '4', '2', '4', '', '', ''),
  </code></pre>
  
  <p>and i would like it to be convert to be like this</p>
  
  <pre><code>INSERT INTO `monthlydata` (`id`, `year`, `monthName`, `stat_id`, `cat_id`, `data`) VALUES
  (1, '2017', 'January', '12', '25', '1'),
  (2, '2017', 'February', '12', '25', '3'),
  (3, '2017', 'March', '12', '25', '1'),
  (4, '2017', 'April', '12', '25', '1'),
  (5, '2017', 'May', '12', '25', '3'),
  (6, '2017', 'June', '12', '25', '4'),
  (7, '2017', 'July', '12', '25', '4'),
  (8, '2017', 'August', '12', '25', '2'),
  (9, '2017', 'September', '12', '25', '4'),
  (10, '2017', 'October', '12', '25', ''),
  (11, '2017', 'November', '12', '25', ''),
  (12, '2017', 'December', '12', '25', ''),
  </code></pre>
  
  <p>is there an easier way to do this using mysql/php</p>