Insert row between different data

Question

I'm Andrew from Italy!

I'm trying to write a script that inserts a blank row between some data in a spreadsheet.

Example, I have this data set:

and I want to obtain something like this:

In other words:

The script should check all the rows and, when the date change and the name change, must add an empty row.

Any idea about this? I've tried to modify a script that I've found online that remove blank rows in a sheet but I'm not able to get any results.

Thanks!

I would get all the data, process it, build a new data set with blank rows, then overwrite the original data. — Alan Wells
@SandyGood thanks for your suggestione. I'm trying to write something that compare the cell content with the previous one and, if different, add a blank row. I'm not good in coding. Do you have some example to start with? — Andrea Volontè

ocordova ocordova · Accepted Answer · 2016-07-26T16:37:17

(: I agree with Sandy Good... Just of the top of my head, here's a piece of code that can get you started:

function doSomething() {
 var spreadsheet = SpreadsheetApp.openById('yourID'), // Get the spreadsheet
     tab = spreadsheet.getSheets()[0], // Get the first tab
     values = tab.getRange(2, 1, tab.getLastRow(), 3).getDisplayValues(), //Get the values beginning in the second row because of the headers
     newValues = [], // Empty array where we're gonna push the new values
     lastDate,
     lastName;

 // Loop through all the values
 for(var i = 0; i <values.length; i++){
   // If the last name is different from the current name or the last date is different from the current date add an empty "row" to the new array
   if((lastDate != undefined && lastName != undefined) && (values[i][0] != lastDate || values[i][1] != lastName)){
     newValues.push(['','','']);
   }

   //Add the current row to the new array
   newValues.push(values[i]);

   //Sets the lastDate and lastName to the current values for the next evaluation
   lastDate = values[i][0];
   lastName = values[i][1];
 }

 //Sets the new values
 tab.getRange(2,1,newValues.length,3).setValues(newValues)

}

Insert row between different data

1 Answers