Hi gang! First time poster here. I'm having a problem figuring out how to count two rows in the source data as one in a pivot table.

I'm wanting to create a pivot table that summarizes the commissions for instructors based on what they have taught. Sometimes there will be one instructor, other times there may be 2 or 3 or 4 instructors. Right now I have the data set up where I have 4 different columns to put in up to 4 different instructors in one row if need be. The problem I'm having is having the pivot table summarize my instructors' commissions if they are in one column for one class but are in another column for a different class. There will be hundreds of classes, so just inserting more rows is not really an option. Any help?

Thanks!