title: How to get pack all the nonnull data from a row of null and non-null data into an array using vbscript
body: <p>I have an excel sheet,which has 144 coulms-(4 columns contains one set).i.e 36 sets i do have. Now how can i take out only the Non-Null data from the 2000X350 Excel sheet matrix data,into an 2D array using VBScript?</p>
  
  <p>Here is an Example sheet:</p>
  
  <pre><code>   PID  T1 T1SD T1CD T1ST T2 T2SD T2CD T2ST T3 T3SD T3CD T3ST T4 T4SD T4CD T4ST ........
      10  a   b          b   t             r                     t   k   l     o
      11                     p   p    m    d   n   n    n    b
      .
      .
  </code></pre>
  
  <p>PID on the column number 11 always.Evey set is comprised of (TN,TNSD,TNCD,TNST) where N=1 to 36. Array will not pick up data into it only iff a set full contains NUll data . Once all the data pick up will be done,it should then relase the data to each row. But thing should be remembered that if 2D array should assign data to the row from where it has been picked up.</p>
  
  <p>Data(1,1)=(a,b,,b,t,,,r,t,k,l,o) During pick up
  Cell(2,12)=(a,b,,b,t,,,r,t,k,l,o) when releasing the data.</p>
  
  <p>that means data should need to mapped to the correct rows(setwise)</p>
  
  <p>Please let me know if you have any confusion.</p>
  
  <p><em><strong>EDIT:</em></strong>
  <em><strong>Output table</em></strong></p>
  
  <pre><code>    PID  T1 T1SD T1CD T1ST T2 T2SD T2CD T2ST  T3 T3SD T3CD T3ST T4 T4SD T4CD T4ST
      10  a   b          b   t              r    t   k   l     o
      11  p   p    m     d   n   n    n    b
  </code></pre>
  
  <p>Thanks,Arup</p>