title: How to transpose multiple rows into multiple columns?
body: <p>Grouping col_1 in ascending values of seq column to display values from comment columns in multiple columns for below sample data:</p>
  
  <pre><code>col_1  |  Seq  |  Comment |
  --------------------------|
  ABC    |   30  |  TestC   |
  ABC    |   50  |  TestE   |
  ABC    |   80  |  TestG   |
  ABC    |   10  |  TestA   |
  ABC    |   60  |  TestF   |
  ABC    |   20  |  TestB   |
  ABC    |   70  |  TestF   |
  ABC    |   40  |  TestD   |
  DEF    |   20  |  TestB   |
  DEF    |   10  |  TestA   |
  GHI    |   10  |  TestA   |
  --------------------------|
  
  Expected output of sql should be:
  Col_1  | Col_2 | Col_3 | Col_4 | Col_5 | Col_6 | Col_7 | Col_8 | 
  -------|-------|-------|-------|-------|-------|-------|-------|
  ABC    | TestA | TestB | TestC | TestD | TestE | TestF | TestG |
  DEF    | TestA | TestB |       |       |       |       |       |
  GHI    | TestA |       |       |       |       |       |       |
  -------|-------|-------|-------|-------|-------|-------|-------|
  </code></pre>