You need to unpivot the table instead of creating a pivot table. Try to use this solution.
You need to transform your table before applying the Unpivot2 macro: