title: VBScript - Combine or Join two arrays
body: <p>My pages are ASP with VBScript. I have two different recordsets and each has it own array (by using RS.GetRows() method).  Basically, I want to combine these two arrays into one array.  Please see my demo below.  </p>
  
  <p>Please help, thank you....</p>
  
  <pre><code>Dim array1
  array1(0,0)="a"
  array1(0,1)="b"
  array1(1,0)="c"
  array1(1,1)="d"
  
  Dim array2
  array2(0,0)="e"
  array2(0,1)="f"
  array2(1,0)="g"
  array2(1,1)="h"
  
  /////  I want to combine into one array something like this. //////
  Dim array1
  array1(0,0)="a"
  array1(0,1)="b"
  array1(1,0)="c"
  array1(1,1)="d"
  array1(0,2)="e"
  array1(0,3)="f"
  array1(1,2)="g"
  array1(1,3)="h"
  
  /////  Basically, same columm numbers, but adding more data/rows to the existing array. 
  OR if this is not doable, is there a way to combine these arrays into a brand new array?
  
  
  /////  I have this much so far, but couldn't get it to work ///////
  For i = 0 to Ubound(array2, 2)
      Redim Preserve array1(i, 1)
      array1(i, 0) = array2(0, i)
      array1(i, 1) = array2(1, i)
  Next
  </code></pre>