title: Is there a way to reverse-text-to-columns in Google Sheets?
body: <p>I have n columns and m rows of cells.</p>
  
  <p><a href="https://i.stack.imgur.com/a1STk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a1STk.png" alt="enter image description here"></a></p>
  
  <ol>
  <li><p>I want to batch concatenate each cell in a row into a <strong>comma-separated</strong> entry: </p>
  
  <blockquote>
    <p>Topic 1, Topic 8, Topic 13, Topic n</p>
  </blockquote></li>
  <li><p>Then, I want to batch concatenate each of these previously concatenated entries into one sequence of <strong>semi-colon-separated</strong> entries:</p>
  
  <blockquote>
    <p>Topic 1, Topic 8, Topic 13, Topic n; Topic 2, Topic 9, Topic 10, Topic n;....</p>
  </blockquote></li>
  <li><p>I would like for the output to be a conversion of all n-columns and m-rows into text in one single cell, with the above format.</p></li>
  </ol>
  
  <p>It's basically a reverse-text-to-columns that reduces a table to a single cell. I have tried doing this with <code>CONCATENATE</code>, but it doesn't scale for n-columns/m-rows, and I can't seem to find a Macro solution. I would greatly appreciate any help in this matter!</p>