Elsevier Macro: Collapse duplicate titles into single rows

[
  {
    "op": "core/column-move",
    "description": "Move column title.identifier.elsevier to position 0",
    "columnName": "title.identifier.elsevier",
    "index": 0
  },
  {
    "op": "core/row-reorder",
    "description": "Reorder rows",
    "mode": "record-based",
    "sorting": {
      "criteria": [
        {
          "reverse": false,
          "caseSensitive": false,
          "column": "title.identifier.elsevier",
          "valueType": "string",
          "blankPosition": 2,
          "errorPosition": 1
        },
        {
          "reverse": false,
          "column": "DateFirstPackageIssue",
          "valueType": "date",
          "blankPosition": 2,
          "errorPosition": 1
        }
      ]
    }
  },
  {
    "op": "core/blank-down",
    "description": "Blank down cells in column title.identifier.elsevier",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "title.identifier.elsevier"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(isBlank(value),\"Not Stated\",value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column VolumeLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "VolumeLastPackageIssue",
    "expression": "grel:if(isBlank(value),\"Not Stated\",value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column NumberLastPackageIssue using expression grel:if(isBlank(value),\"Not Stated\",value)",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "NumberLastPackageIssue",
    "expression": "grel:if(isBlank(value),\"Not Stated\",value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-addition",
    "description": "Create column Last Issue Statement at index 8 based on column DateLastPackageIssue using expression grel:value+\",\"+if(isNonBlank(cells.VolumeLastPackageIssue.value),cells.VolumeLastPackageIssue.value,\"\")+\",\"+if(isNonBlank(cells.NumberLastPackageIssue.value),cells.NumberLastPackageIssue.value,\"\")",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "newColumnName": "Last Issue Statement",
    "columnInsertIndex": 8,
    "baseColumnName": "DateLastPackageIssue",
    "expression": "grel:value+\",\"+if(isNonBlank(cells.VolumeLastPackageIssue.value),cells.VolumeLastPackageIssue.value,\"\")+\",\"+if(isNonBlank(cells.NumberLastPackageIssue.value),cells.NumberLastPackageIssue.value,\"\")",
    "onError": "keep-original"
  },
  {
    "op": "core/multivalued-cell-join",
    "description": "Join multi-valued cells in column Last Issue Statement",
    "columnName": "Last Issue Statement",
    "keyColumnName": "title.identifier.elsevier",
    "separator": "|"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Last Issue Statement using expression grel:with(value.split(\"|\").sort(),a,a[a.length()-1])",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "Last Issue Statement",
    "expression": "grel:with(value.split(\"|\").sort(),a,a[a.length()-1])",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Last Issue Statement using expression grel:value.replace(\"Not Stated\",\"\")",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "Last Issue Statement",
    "expression": "grel:value.replace(\"Not Stated\",\"\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-split",
    "description": "Split column Last Issue Statement by separator",
    "engineConfig": {
      "facets": [],
      "mode": "record-based"
    },
    "columnName": "Last Issue Statement",
    "guessCellType": true,
    "removeOriginalColumn": true,
    "mode": "separator",
    "separator": ",",
    "regex": false,
    "maxColumns": 0
  },
  {
    "op": "core/column-removal",
    "description": "Remove column DateLastPackageIssue",
    "columnName": "DateLastPackageIssue"
  },
  {
    "op": "core/column-removal",
    "description": "Remove column VolumeLastPackageIssue",
    "columnName": "VolumeLastPackageIssue"
  },
  {
    "op": "core/column-removal",
    "description": "Remove column NumberLastPackageIssue",
    "columnName": "NumberLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Last Issue Statement 1 to DateLastPackageIssue",
    "oldColumnName": "Last Issue Statement 1",
    "newColumnName": "DateLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Last Issue Statement 2 to VolumeLastPackageIssue",
    "oldColumnName": "Last Issue Statement 2",
    "newColumnName": "VolumeLastPackageIssue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Last Issue Statement 3 to NumberLastPackageIssue",
    "oldColumnName": "Last Issue Statement 3",
    "newColumnName": "NumberLastPackageIssue"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==4,(inc(inc(toDate(value),1,\"year\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==4,(inc(inc(toDate(toString(value)),1,\"year\"),-1,\"day\")),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==7,(inc(inc(toDate(value),1,\"month\"),-1,\"day\")),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column DateLastPackageIssue using expression grel:if(length(value)==10,toDate(value),value)",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "DateLastPackageIssue",
    "expression": "grel:if(length(value)==10,toDate(value),value)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column VolumeLastPackageIssue using expression grel:value.toString()",
    "engineConfig": {
      "mode": "record-based",
      "facets": []
    },
    "columnName": "VolumeLastPackageIssue",
    "expression": "grel:value.toString()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column NumberLastPackageIssue using expression grel:value.toString()",
    "engineConfig": {
      "mode": "record-based",
      "facets": []
    },
    "columnName": "NumberLastPackageIssue",
    "expression": "grel:value.toString()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/row-removal",
    "description": "Remove rows",
    "engineConfig": {
      "mode": "row-based",
      "facets": [
        {
          "omitError": false,
          "expression": "isBlank(value)",
          "selectBlank": false,
          "invert": false,
          "selectError": false,
          "selection": [
            {
              "v": {
                "v": true,
                "l": "true"
              }
            }
          ],
          "name": "title.identifier.elsevier",
          "omitBlank": false,
          "type": "list",
          "columnName": "title.identifier.elsevier"
        }
      ]
    }
  }
]