The MAP function in Google Sheets is a powerful function for working with ranges (arrays) of data.
It takes array(s) of data as an input and “maps” each value to a new value based on a custom LAMBDA function.
MAP is a more modern, functional approach to array formula type problems.
#GoogleWorkspace