title: How to unpivot a crosstab like table?
body: <p>After importing data from an excel document I ended up with a table that looks like this (quite similar to a pivot table):</p>
  
  <pre><code>EMPLOYEEID | SKILL1 | SKILL2 | SKILL 3
  ---------------------------------------
     emp1    |    1   |        |    3
     emp2    |    2   |    3   |    
     emp3    |        |        |    1
     emp4    |        |    2   |    3
  </code></pre>
  
  <p>And in my database I have another table which stores each level of knowledge of each skill for
  every employee:</p>
  
  <pre><code>EMPLOYEEID |  SKILLID  | LEVEL_OF_KNOWLEDGE
  ------------------------------------------
     emp1    |  SKILL1  |         1   
     emp1    |  SKILL3  |         3       
     emp2    |  SKILL1  |         2
     emp2    |  SKILL2  |         3
     emp3    |  SKILL3  |         1   
     emp4    |  SKILL2  |         2
     emp4    |  SKILL3  |         3
  </code></pre>
  
  <p>My question is, how can I retrieve the data from the first table and store it in the second one? Is it possible using only Access queries or have I to deal with vba?</p>
  
  <p>I have found plenty of examples doing the opposite (pivoting the second table to get the first one) but I haven't managed to find the way to do solve this case.</p>