title: Google App Script to combine columns
body: <p>I have a google spreadsheet with multiple columns that have variable row counts in each column.  I would like to combine all the columns into one column.</p>
  
  <p>So if the following is the data:
  Column 1, column 2, Column 3, Column 4
  Row 1: A, B, C, D
  Row 2: ,,,E</p>
  
  <p>I would want to get 
  Row 1: A
  Row 2: B
  Row 3: C
  Row 4: D
  Row 5: E</p>
  
  <p>I would like this to be non-destructive to the original sheet so it should create a new spreadsheet tab with a unique name. The unique name is important b/c i would like to run this function on multiple spreadsheets that are all different. The unique name will avoid overlap.</p>
  
  <p>The request is to help me write the script to do this transpose in google apps spreadsheets</p>
  
  <p>Thank you for the help!</p>