Counting Total Number of Customers that Purchased Fruit Items Listed in Multiple Columns

Hello!

Long time lurker who has appreciated many fixes the community has provided.

I've finally come across something I couldn't describe succinctly enough to use in the search bar and I believe there is an easier answer than what I'm trying to accomplish.

I have a data set which contains customers who made multiple orders. The order themselves are listed in each column and tied to the specific customer along with the date the order was made. I want to create a Pivot Table that tells me the total number of each type of fruit ordered broken into aging categories. I've attached a copy of an example dataset along with what I want the Pivot Table to look like (Desired Pivot Table tab) and what the actual Pivot Table looks like (Actual Pivot Table tab).

I'm not sure if what I want to do is possible, but it has to only be done in Excel since this is the only program we have access to at my company. Is this possible?

Thank you all in advance!

In stead of a pivot, why not just take your columns (apple, orange, banana, pear) and copy/paste-transpose them into rows on a clean tab. Then put your aging categories across the top in the columns and write a countifs formula to count the number of customer orders that meet the criteria of both being in the correct aging bucket as well as the right fruit?

Does that make sense?