STATS_SPLIT_COLS Function Reference in Google Sheets | ALS Stats Documentation

This video is reference documentation for the STATS_SPLIT_COLS function in the ALS Stats add-on for Google Sheets. It focuses on the exact behavior of splitting one numeric dataset into multiple columns by a category column, using a single example sheet.

00:00 Function overview and scope
00:30 Basic split by a category column
00:43 Parameters description
01:07 Output structure and meaning
02:05 Include only selected measure columns
02:14 Result: only x and x1 are split
02:46 Exclude the splitting column itself
02:56 Result: all except the split column
03:28 Use regex to split only question columns
03:37 Result: only question columns by pattern
04:06 Apply custom labels to split groups
04:17 Result: human-readable group labels
04:42 Summary

The video shows STATS_SPLIT_COLS splitting a table by a numeric category column (`groupCode`), then compares outputs when using different `colFilter` rules: all columns, an explicit include list (x,x1), a negative rule that excludes only the split column, and a regex selector that targets question columns (headers starting with "q"). It also demonstrates how a labels string remaps raw codes (1,2,3) to descriptive labels in the resulting column headers.

The scope is limited to observable behavior on this dataset: which columns are split, how headers are constructed, and how blanks appear where a group has no values. It does not include theory of categorical variables, regex syntax tutorials, or general Google Sheets training, and it is not a step-by-step tutorial.

Link to documentation play list: https://www.youtube.com/playlist?list=PL5GYWQjgDdVAaHF7oUzKcLXRtPfk7BK69
___________
Install ALS Stats (Google Sheets add-on):
https://workspace.google.com/marketplace/app/als_stats/558005348178

Function documentation:
https://als-stats.net/functions/stats_split_cols/

Article version of this video:
https://als-stats.net/blog/functions-splitcols
Valid for version:
1.0

#googlesheets #alsstats #stats_split_cols #splitdata #googlesheetsaddon #datapreparation

Видео STATS_SPLIT_COLS Function Reference in Google Sheets | ALS Stats Documentation канала Als Stats