Advertisement
RemcoE33

Split concat

Jul 31st, 2021
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /**
  2. * Returns converterd timestamps.
  3. *
  4. * @param {A1:B5} range - Input range.
  5. * @param {3} column - Enter the column number that needs to be split.
  6. * @param {","} delimiter - Enter the delimiter.
  7. * @return {array} range with values concatenated to the split outcome.
  8. * @customfunction
  9. */
  10.  
  11. function SPLIT_CONCAT(range, column, delimiter) {
  12.  
  13.   const output = [];
  14.   range.forEach(row => {
  15.     const split = row[column - 1].split(delimiter);
  16.     row.splice(column - 1,1);
  17.       split.forEach(col => {
  18.        output.push([...row,col.trim()]);
  19.     })
  20.   })
  21.  
  22.   return output;
  23.  
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement