A better way to LISTAGG in Google Sheets (with Pivot Tables)
The SQL LISTAGG function in Snowflake or Redshift (or STRING_AGG in BigQuery) are aggregation functions that condense textual data into easy-to-view reports. Similar to other aggregation functions (like SUM or MAX), these functions aggregate data according to the column names in a GROUP BY clause. This is a common pattern for rolling up a column …
A better way to LISTAGG in Google Sheets (with Pivot Tables) Read More »