product idcolumn, as well as one column per month for a fiscal year:
Feb, etc. The first row in the
Jancolumn contains the quantity of the first product sold in
Jan, the second row contains the quantity of the second product sold in
Dataframes > Unpivot Dataframe. Then, configure your
ID Variables. These columns will be present in the unpivoted dataframe. In our example, you would select the
Values. Each column header will go in the variables column, and the column values will go in the values column. In our example, you would select all the month columns.