Pivot columns into rows and columns. Values are count of pairs of rows and columns or aggregation of another column.
- Click "+" button and select "Pivot"
- You can also select "Pivot" from column menu of the column you want to pivot.
Rows- select columns for Pivot Row.
Columns- select colums for Pivot Columns.
Value(Optional) - A column for values in output data frame.
- Remove NA - The default is TRUE. If NA should be removed from value.
- Fill NA with - The default is 0. This is what should be used for missing value in groups.
if you set row: clarify, colour columns: certification value: price fill:0
it returns data frame with rows of combinations of clarity and colour and with columns of certification. Values are sum of price and missing values are filled by 0.