Create a Table from data set

Well. Not pretty, but this macro should automate the data to the state where you can perform the pivot table. I used a helper column to do the Sum on the pivot table just an FYI.

PS: Copy your data to the Worksheet named "In" first before run the macro.