Pivot Help Please

[posfog]

Hi All,
I have a large data set with details from A1 to H1 containing details like Date, Time Shift, Week Number etc then from K1 to CY1 showing issues found.

These cells are filled in for each product checked as a single part could have multiple issues.

I am now trying to pivot this information and would like the issues running from top to bottom with the titles used in Row 1 but for some reason i am unable to get this to work which is then leaving me with a issues of not being able to report on highest issues found with products.


Is any one able to help at all please?

Regards

 

[steve the fish]

Yeah thats not how you need to present data to a pivot. You need flat data so each issue will need its own new row.