title: Build a tree like representation of data in Excel?
body: <p>I have a bunch of raw data in this fashion:</p>
  
  <pre><code>Parent  |  Data
  ---------------
  Root    | AAA
  AAA     | BBB
  AAA     | CCC
  AAA     | DDD
  BBB     | EEE
  BBB     | FFF
  CCC     | GGG
  DDD     | HHH
  </code></pre>
  
  <p>Which needs to be converted into a tree like fashion.
  This basically needs to end up in an excel spreadsheet.
  How can I convert the above data into the following:</p>
  
  <pre><code>AAA |      |
      | BBB  |
      |      | EEE
      |      | FFF
      | CCC  |
      |      | GGG
      | DDD  |
      |      | HHH
  </code></pre>
  
  <p>Is there any easy way to do this using only VBA?</p>