pivot product?

[zazzz]

I've been left an assignment and I dont even understand the question much less how to solve it. We're allowed to research online but google hasn't been helpful.

Here's the instruction for this question:

"Pivot product data table into new cell and link to a dynamic chart with a toggle for Product"


I've been given a data table. I'll attach that below. But not sure what to do from there. Can anyone help?

Product	Nov	Dec	Jan	Feb
Product 1	2	3	4	5
Product 6	7	8	9	10
Product 7	17	18	19	20
Product 8	27	28	29	20
Product 9	37	38	39	310

EDIT - I think "Product Data Table" may be the name of the data given? If so that makes this a bit more understandable. But still dont get the rest of the sentence.

[NeedForExcel]

that looks more like a final output to me. Maybe you will have to understand a bit more about what exactly needs to be done.

[BadlySpelledBuoy]

Not sure if this is exactly what you need, but the data has been tabulated using a pivot table and by using the filter in G4 you can restrict the data to one/some/all of the products.

BSB