title: Matlab / Simulink : create array from fact table
body: <p>Would greatly appreciate some help with the following challenge:</p>
  
  <p>I am importing a fact table from a database into a Matlab table. The fact table consist of a sequence of observations across several categories as follows:</p>
  
  <pre><code>SeqNo       Cat    Observation
  1           A      0.3
  1           B      0.5
  1           C      0.6
  2           B      0.9
  2           C      1.0
  3           A      1.2
  3           C      1.5
  </code></pre>
  
  <p>I need now to delinearize the fact table and create a matrix (or another table) with the categories representing columns, i.e. something like this:</p>
  
  <pre><code>Seq    A      B     C
  1     0.3    0.5   0.6
  2     NaN    0.9   1.0
  3     1.2    NaN   1.5
  </code></pre>
  
  <p>I played around with findgroup  and the split-apply-combine workflow, but no luck. In the end I had to resort to SPSS Modeler create to create a properly structured csv file for import, but would need to achieve this fully in Matlab or Simulink. </p>
  
  <p>Any help would be most welcome.</p>