Google Apps Script - Data Manipulation

I believe your goal is as follows.

• You have a sheet of "dataset" including various data of 3 columns as shown in your question.
• You want to split the data by each manufacturer (Ford, Toyota, Tesla).
• You want to achieve this using Google Apps Script.

In this case, how about the following sample script?

Sample script:

Please copy and paste the following script to the script editor of Spreadsheet. And, please set the variable of datasetSheetName and list for your actual situation. And, please run myFunction.

function myFunction() {
  const datasetSheetName = "dataset"; // Please set the sheet name of dataset.
  const list = ["Ford", "Toyota", "Tesla"]; // Please set "manufacturer" list you want to retrieve.

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const [, ...sourceValues] = ss.getSheetByName(datasetSheetName).getDataRange().getValues();
  const obj = sourceValues.reduce((o, r) => {
    const t = list.find(e => r[0].toLowerCase().includes(e.toLowerCase()));
    if (t) o[t] = o[t] ? [...o[t], r] : [r];
    return o;
  }, {});
  list.forEach(e => {
    const sheet = ss.getSheetByName(e) || ss.insertSheet(e);
    sheet.getRange(sheet.getLastRow() + 1, 1, obj[e].length, obj[e][0].length).setValues(obj[e]);
  });
}

Note:

• I think taht when this script is run, your goal is obtained. But, if an error occurs, in that case, I think that it is required to know your Spreadsheet.

References:

• reduce()
• forEach()

Added:

About your following new request,

is there a way to update the code above so that it works even if the manufacturer column is the 2nd column in the dataset and not the first?

In this case, please modify above script as follows.

From:

const t = list.find(e => r[0].toLowerCase().includes(e.toLowerCase()));

To:

const t = list.find(e => r[1].toLowerCase().includes(e.toLowerCase()));

Try

function myFunction() {
  const list = ["Ford", "Toyota", "Tesla"];
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const [headers, ...values] = ss.getSheetByName("Sheet1").getDataRange().getValues();
  list.forEach(elem => {
    const result = [headers, ...values.filter(r => r[0].includes(elem))]
    const sheet = ss.insertSheet(elem);
    sheet.getRange(1, 1, result.length, result[0].length).setValues(result);
  })
}

filter

forEach