title: Get Dataset as Header for Another Table
body: <p>I get the columns and the data of all surveys I have in the online database through my API an separately. </p>
  
  <p>The first example are the column headers of the first two surveys</p>
  
  <p><strong>Column Table</strong></p>
  
  <pre><code>ID  Col1    Col2         Col3
  ------------------------------------    
  0   Name    Birhtdate    Country
  1   Time    Name         Address
  </code></pre>
  
  <p>The data I get for the first survey is like</p>
  
  <p><strong>Data Table</strong></p>
  
  <pre><code>ID  Col1    Col2        Col3
  ------------------------------------    
  0   James   11-11-2011  Japan
  1   Tobi    26-02-2014  India
  </code></pre>
  
  <p>Now I want to merge the data and the columns so that the column names are the header of the final table like</p>
  
  <p><strong>Final Table</strong></p>
  
  <pre><code>ID  Name    Birthday     Country
  ------------------------------------    
  0   James   11-11-20111  Japan
  1   Tobi    26-02-2014   India
  </code></pre>
  
  <p>All the attemps I have made yet with Select statements gave me </p>
  
  <p><strong>Wrong Result Table</strong></p>
  
  <pre><code>ID  Col1    Col2         Col3
  ------------------------------------    
  0   Name    Birthdate    Country
  1   James   11-11-20111  Japan
  2   Tobi    26-02-2014   India
  </code></pre>
  
  <p>Could anyone help me get the final table (view, temp Table... whatever) out of my data? I am working with SQL-Server 2016</p>