I have a main data sheet with many columns, 5 of which are "Issue (#1-5)", 5 are "Issue Time", date, machine number and part. In the issue column, it can be a number between 1 and 10.

What I am trying to do is use a pivot table to combine all of the issue columns so in column 1 of the pivot table, there are numbers 1-10 for each issue code, and in column 2 have the sum of the issue time for each issue code.

I have been able to do this by using 5 pivot tables and combining them all into 1, but I am wondering if there is a way to do it in just 1 table.