Resolved: Google Sheets – shift the cell value according to the name beside the cell

=QUERY(ArrayFormula(FLATTEN(SPLIT(REPT($AL11:$AL13&"@",$AM11:$AM13),"@"))),"where Col1 is not null")

function onEdit(e) {
  const ss = e.source;
  const range = e.range;
  if(range.getColumn() == 2 && range.getRow() > 1) {
    const sheet = ss.getActiveSheet();
    const lastRow = sheet.getLastRow();
    const dataRange = sheet.getRange(2, 1, lastRow - 1, 2);
    const dataValues = removeEmptyRows(dataRange.getValues());
    const outputRange = dataRange.offset(0, 2);
    const outputData = removeEmptyRows(outputRange.getValues());

    let output = [];

    dataValues.filter(x => x[1] && x[1] > 0).forEach(row => {
      const [fruit, count] = row;
      let currentFruit = outputData.filter(x => x[0] == fruit);
      let currentCount = currentFruit.length, rows;

      if(currentCount < count) {
        rows = count - currentCount;
        currentFruit.push(...Array(rows).fill([fruit, '']));
      }
      else if(count < currentCount) {
        rows = currentCount - count;
        currentFruit = currentFruit.slice(0, -1 * rows);
      }
      output.push(...currentFruit);
    });

    outputRange.clearContent();
    sheet.getRange(2, 3, output.length, output[0].length).setValues(output);
  }
}

function removeEmptyRows(array) {
  return array.filter(x => x.filter(String).length > 0)
}

function onEdit(e) {
  const ss = e.source;
  const range = e.range;
  if(range.getColumn() == 2 && range.getRow() > 1) {
    // Needed values to modify
    // Input: Data that holds how many items are in each category
    const inputRowStart = 2;  // Input starts at:
    const inputColStart = 1;  // ROW 2, COL 1 (A2)
    // Output: Data where the output is written 
    const outputRowStart = 2; // Output starts at:
    const outputColStart = 3; // ROW 2, COL 3 (C2)
    const outputCols = 3;     // 3 COLS (Fruits, Details, Date)

    const sheet = ss.getActiveSheet();
    const lastRow = sheet.getLastRow();
    const inputRange = sheet.getRange(inputRowStart, inputColStart, lastRow - 1, 2);
    const inputValues = removeEmptyRows(inputRange.getValues());
    const outputRange = sheet.getRange(outputRowStart, outputColStart, lastRow - 1, outputCols);
    const outputData = removeEmptyRows(outputRange.getValues());

    let output = [];

    inputValues.filter(row => row[1] > 0).forEach(row => {
      const [fruit, count] = row;
      let currentFruit = outputData.filter(row => row[0] == fruit);
      let currentCount = currentFruit.length, rows;

      if(currentCount < count) {
        rows = count - currentCount;
        currentFruit.push(...Array(rows).fill([fruit, ...Array(outputCols - 1).fill('')]));
      }
      else if(count < currentCount) {
        currentFruit = currentFruit.slice(0, count);
      }
      output.push(...currentFruit);
    });

    outputRange.clearContent();
    sheet.getRange(outputRowStart, outputColStart, output.length, output[0].length).setValues(output);
  }
}

function removeEmptyRows(array) {
  return array.filter(row => row.filter(String).length > 0)
}