title: Transform headers to cells and join
body: <p>Current data:</p>
  <p><a href="https://i.stack.imgur.com/WAyBR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WAyBR.png" alt="Current data" /></a></p>
  <p>Desired outcome:</p>
  <p><a href="https://i.stack.imgur.com/AYX64.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AYX64.png" alt="desired outcome" /></a></p>
  <p>I considering writing a basic VBA script, to loop through and concatenate. However since this will be running through 44 columns 25k-130k rows. I would prefer a more efficient solution.</p>
  <p>I believe this could perhaps be accomplished fairly efficiently with power query. Any assistance would be greatly appreciated.</p>