title: How to achieve below scenario in MS Access?
body: <p>table1:</p>
  
  <pre><code>test1   test2   test3   rest1   rest2
  1         a       z      21      82
  2         s       z      26      81
  2         a       z      54      82
  </code></pre>
  
  <p>Expected result:</p>
  
  <pre><code>rest1   rest2   Filed1  filed2
    21      82      test1   1
    26      81      test2   a
    54      82      test3   z
    21      82      test1   2
    26      81      test2   s
    54      82      test3   z
    21      82      test1   2
    26      81      test2   a
    54      82      test3   z
  </code></pre>
  
  <p>I tried transform, pivot, union, but unable to achieve the above.</p>