Hello,
I am trying to consolidate sales data within a table so that I can see the total revenue for each Product Segment by consolidating multiple Items.
I have attached an example based on a much larger data set.
I am looking to consolidate the data so that I can see the revenue each month and total amount (column S) for each Product Segment from each Company.
For example, I would be able to consolidate the data for Company A Kits and see that the total FY Amount is 12,866.01
In addition, I am looking to combine data from separate tables which cover different periods of time and some different products. For example, I would wish to combine the data on sheet 2 with the data in sheet 1. Some of the products (0001 and 0002) also appear on the table on sheet 1, while others (0051) appear only on sheet 2. Is there a way to combine such data?
Any help would be much appreciated, my actual data set is well over 7,000 entries so I'm looking for an automated way to combine data.
Thank you!
Bookmarks