Description
The PIVOTLONGER function transforms a table, moving some of its columns to rows.
Usage
PIVOTLONGER (<Table Expression>, <Column Selector Expression>, <Category column name>, <Value column name>)
The PIVOTLONGER function evaluates to a new table.
Examples
Pivoting disaggregate fields into rows
If you have a form with aggregate values by gender, it may be useful pivot this longer:
PIVOTLONGER(schools, COLUMNS(Girls, Boys), "Sex", "Count")