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!
Bookmarks