I'm working on an excel worksheet where I have 2 spreadsheets running. On one of them I have a list transactions with different categories such as date, name of product, category. amount, price, etc...
In the other one I have a list of the different categories of products so that I can track which products are selling better and so on.
My question is: How can you go from having a long list of transactions to making excel split these up according to the category and fill them in in different locations.
Any sort of help that can bring me closer to an answer is appreciated. Thank you in advance.