Data Generation

Showing all Cheats

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.

Get all combinations from sets in multiple lists in Google Sheets with COMBINE

Output all the different combinations of a sets of text in three formats.

Lucas A. Browne Dias