title: Is it possible to combine multiple cells into one while also omitting empty cells?
body: <p>Is it possible to combine cells in one 'Outcome Cell' while simultaneously omitting any cell that is blank?</p>
  
  <p>Below is an image of the desired outcome. Currently I'm having to use =CONCATENATE to get this outcome but then I have to go through it to remove all of the blank cells manually (with over 50 columns and 1000 rows this takes a long time).  </p>
  
  <p><img src="https://i.stack.imgur.com/JVr1Y.png" alt="Google sheets screenshot"></p>
  
  <p>Also is a link to the spreadsheet for you to see:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1Pjdz6NuzJqNuIRjtF_qnAm2S9UjYfpXb-zRF7xSFMvE/edit?usp=sharing" rel="nofollow noreferrer">Excel spreadsheet</a></p>