title: Transpose mutiple rows in one column MS access
body: <p>Looking to transpose data below</p>
  
  <p>3 rows</p>
  
  <pre><code>Order #         Carton       SKU    QTY Date       Hub  PODSTATUS
  07232768343200  0           4384173 1   2018/08/13  CRB   X1
  07331558939200  13746809    1724640 1   2018/08/19  CRB   X1
  07332717287200  13746811    1724640 1   2018/08/19  CRB   X1
  </code></pre>
  
  <p>to</p>
  
  <p>just one column</p>
  
  <pre><code>07232768343200
  0
  4384173
  1
  2018/08/13
  CRB
  X1
  07331558939200
  13746809
  1724640
  1
  2018/08/19
  CRB
  X1
  07332717287200
  13746811
  1724640
  1
  2018/08/19
  CRB
  X1
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/WgxmN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WgxmN.png" alt="final result"></a></p>
  
  <p>any help is appreciated thanks!</p>
  
  <p>RTam</p>