Convert a Google Sheets range to JSON with TABLE_TO_JSON
Convert a range to a JSON object with multiple items.
Convert a Google Sheets range into URL key & value parameters with TABLE_TO_KV
Convert a table of data into properly encoded key and value strings for passing parameters on a URL or elsewhere.
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Convert a range of dates to financial half-year in four different output formats.
Transform dates to financial quarter in Google Sheets
Convert dates to financial quarter for pivoting metrics by quarter.