# Retrieving cells without blank using GAS

This is a sample script for retrieving cells without blank cells. Figure 1 shows the sample spreadsheet. In this sheet, the row 14 has one space.

Data is retrieved as follows.

  var data = SpreadsheetApp
.getActiveSheet()
.getRange('a1:a30')
.getValues();


## 1. Retrieving cells with spaces and no blank cells.

  var Result = [i for each (i in data)if (i)].join('');


Result : Hello World

## 2. Retrieving cells without both spaces and blank cells.

  var Result = [i for each (i in data)if (isNaN(i))].join('');


Result : HelloWorld