<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Spread |
Spread a column into multiple new columns. Also called a wide pivot or crosstab.
One.
•Select the Key column and Value column you wish to spread.
•Missing values is used for values missing from the input dataset.
With Quarter and Amount columns spread:
Gives:
•If there are rows that are duplicates, apart from the value column, this will cause errors.
•New columns are added at the right end. You can change the column order with Reorder Cols.
•You can merge the new columns into a single column with Concat Cols.
•The opposite of Spread is Gather.