title: Transposing rows into a single column while copying data in other columns
body: <p>I'm extracting data from the SQL and some rows need to be transposed into a column while copying the other data that is unique for that table
  Need a formula to read all the columns and paste new rows and copy data.
  This is just an example,depending on the days I need as many rows in one column to be transposed. Original Data is in 50,000+ Rows
  Any suggestions are welcomed</p>
  
  <p><strong>Before</strong></p>
  
  <pre><code>Order   Line    Item    Day Day2   Day3  Day4  Day5  Day6   Day7
  2000    1      Apple    Mon Tue    Wed         Fri   Sat    Sun  
  2000    2      Orange   Mon               Thu               Sun  
  etc...
  </code></pre>
  
  <p><strong>After</strong></p>
  
  <pre><code>Order   Line    Item    Day
  2000    1       Apple   Mon
  2000    1       Apple   Tue
  2000    1       Apple   Wed
  2000    1       Apple   Fri
  2000    1       Apple   Sat
  2000    1       Apple   Sun
  2000    2      Orange   Mon
  2000    2      Orange   Thu
  2000    2      Orange   Sun
  </code></pre>