PeterWhitfield Red Ribbon

Thanks. I made the changes as you suggested and can see all the Items ordered (with summed quantity) for each customer. I will continue in Excel.

Thank you! This is great and is 90% of what I was looking for. Is there a way to show the Top 10 items for each customer, rather than just the 10 ten items overall? (Restricting the results to 10 Max Results will only show the 10 ten items overall, not 10 for each customer)