title: Concatenate power query columns that are offset from each other
body: <em><strong>The problem</strong></em>
  <p>I have a data set with two header rows. I've transposed the rows into columns to work with the headers before combining, but I need help with concatenation of <code>column1</code> into <code>column2</code>, since past row 7 the columns are offset from one another by one row (see example image).</p>
  <em><strong>The goal</strong></em>
  <p>I've tried to use replace and concatenate myself with an index, but have been unable to achieve the desired end result where <code>column2 row 8</code> is concatenated with <code>column1 row 7</code>, so that when I combine these columns and transpose again the headers will be correctly labeled (see example image).</p>
  <p>Thank you for any suggestions and your time.</p>
  <p>Example image:<br />
  <img src="https://i.stack.imgur.com/abWfE.jpg" alt="" /></p>