title: Reversing Text to Columns in Excel/Calc
body: <p>Most spreadsheet software I've used has a <strong>text-to-columns</strong> function that splits a single column into multiple columns using several criteria (delimiter, # of character, etc).  I want to do this <strong>in reverse</strong>.</p>
  
  <p>I know I can use a formula to create a third column with the values of the two cells concatenated together with a delimiter between them but this seems clunky.</p>
  
  <p>Why is this not a built in function?  Or is it there somewhere that I can't see?</p>