title: How to Transpose Columns to Rows and add redundant data
body: <p>I'm trying to find a solution in Power Query to transpose Table 1 into Table 2 (in the link). I have seen other transpositions on this forum but not one quite like this where I need redundant data to be added. Does anyone know a way to do this type of transposition using Power Query or Excel in general?</p>
  
  <p>How can I transpose Table 1 to look like Table 2?</p>
  
  <p><a href="https://i.stack.imgur.com/bYLge.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bYLge.png" alt="  "></a></p>
  
  <p>Looking for suggestions...</p>