The spreadsheet is currently in this Google Sheets format.
- I am trying to pull out the data from sheet1 table to sheet2
…transposed as follows in the 2nd image.
…transposed as follows in the 2nd image. 
- Original data will grow…a new row every period
- So Query output needs to grow … a new column every period
I have not been able to accomplish this and keep things dynamic.