Hello all - i've been following this forum for a while, and have found your feedback incredibly valuable!
Could you advise me re the following?
BACKGROUND:
I have over 3000 rows of data in an excel sheet where I need to know: how much each customer spends with us; and what products they purchase.
Each customer can have multiple rows of data assigned to them i.e. they purchase a number of products (some are the same and others are different).
I've attached a sheet providing an example outline.
REQUEST:
Could you advise re what is the quickest way to summarise who buys what and spends how much?
I look forward to your responses.
Kindest regards,
Irfan.
Bookmarks