title: PowerBi Transpose - Table
body: <p>I have an excel file that needs to be transposed from multiple columns into table format, but am having trouble merging the rows in Power Query.</p>
  
  <p>Sample Data</p>
  
  <p><a href="https://i.stack.imgur.com/zTG2s.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zTG2s.png" alt="Sample Data"></a></p>
  
  <p>Expected Outcome</p>
  
  <p><a href="https://i.stack.imgur.com/pxxWh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pxxWh.png" alt="Expected Outcome"></a></p>
  
  <p>Thanks a lot for your help in advance.</p>