title: Excel: Transpose column to row and filter the table based on the new row
body: <p>I have the following table </p>
  
  <pre><code>A     B     C     D
  -------------------
  sa  s21    os   v12  
  sa  s21    hs   v14  
  rd  s22    ft   v16  
  zt  s23    pq   v13  
  zt  s23    et   v15  
  hp  s26    zu   v17
  </code></pre>
  
  <p><em>Column A : there exist doublicate values</em></p>
  
  <p><em>Column C : there are unique</em> </p>
  
  <p>I want to Transpose the column "A" to new row (Unique value) as a column header in other worksheet(helper) and then filter like the following:</p>
  
  <pre><code>sa    rd     zt    hp
  ----------------------
  os    ft     pq    zu
  hs    -      et    -
  </code></pre>
  
  <p>Any solution - as a formula or VBA? </p>