title: SQL Query to transpose rows to columns in MS Access database
body: <p>I am using MS Access DB it has a table named ‘tssStockMaster’ with fields (PartNo, ItemName,Stock,Workshop) as shown in the image with following data.</p>
  
  <p><a href="https://i.stack.imgur.com/BzH6n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BzH6n.png" alt="table : tssStockMaster with data"></a></p>
  
  <p>Now I am unable to write a query in MS Access Database using SQL to get the following output such that the stock quantity is shown for each workshops against each item name(group by PartNo).</p>
  
  <p><a href="https://i.stack.imgur.com/rctxT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rctxT.png" alt="Required Output using SQL query in ms access database"></a></p>
  
  <p>Since we cant use PIVOT in MS Access how can I achieve this ?</p>