Navigation: Reference > Transforms >
Gather multiple columns into new key and value columns. Also called unpivot, long pivot or group by.
Gather 'Q1', 'Q2', 'Q3' and 'Q4' columns into 1 column.
•Select the Columns you wish to gather.
•Set Key column name to the name of the new key column, which will have values based on the names of the columns selected.
•Set Value column name to the name of the new value column, which will have values based on the values in the columns selected.
•New columns are added at the right end. You can change the column order with Reorder Cols.
•You can merge the value and key columns into a single column with Concat Cols.
•The opposite of Gather is Spread.