title: How to grab all non-empty cell data in row - Google Sheets Script Editor
body: <p>I'm not sure if this is even possible, and to be quite honest, I haven't tried many things because I wasn't sure where to even start. I'm using the Script Editor from Google Sheets, btw. I know there are SpreadsheetApp.getRange() and another to get the values or something like that. But what I want is a bit specific.</p>
  
  <p>Is there a way to grab all the cell data in a given row and put it into an array? The rows will vary in size, that's why I can't do an exact range.</p>
  
  <p>So for example, if I were to have rows have these values:</p>
  
  <pre><code>abc | 123 | 987 | efg
  blah| cat | 654
  </code></pre>
  
  <p>I want to be able to grab those values and place them into an array like ["abc", "123", "987, "efg"]. And then if I run the function on the next row, it'd be ["blah", "cat", "654"].</p>
  
  <p>Actually, it can be placed into any data type as long as there's a delimiter I'd be able to use.</p>
  
  <p>Thank you in advance!</p>