CONCATENATE questions

`Array.prototype.flat` creates a new array with all sub-array elements concatenated into it recursively up to the specified depth. It helps to flatten nested arrays into a single array. 

const arr = [1, [2, [3, [4]]]];
const flatArr = arr.flat(2);
console.log(flatArr); // [1, 2, 3, [4]]

`Array.prototype.flat` creates a new array with all sub-array elements concatenated into it recursively up to a specified depth. It can flatten nested arrays to a specified level. 

const arr = [1, [2, [3, [4]]]];
const flatArr = arr.flat(2);
console.log(flatArr); // [1, 2, 3, [4]]

The CONCATENATE function combines multiple text strings into one. For example, CONCATENATE('Hello', ' ', 'World') results in 'Hello World.' This is useful for creating full names from separate first and last names or merging data from multiple columns into a single column.