Hello All! I'm working with two sheets of data, one sheet has a list of page views by date, another sheet has sales data by date. I need to combine the two sheets to run some historical analysis on it. Where I'm running into a problem is that every sale is listed on its own line, not by date, unlike the page views which is one line per date. Is there a way to combine the two sheets with total sales based only on date? I've attached a sample sheet that will be similar to the data I will be working with. I know I can process all this manually for small stuff, but there will be much larger files/data to look through. Wondering what the best way to go about this is.

For clarity, on page one I added column D "Sales" to pull over total sales by date from the second sheet

TEST Historical Data Sales.csv


Thank you in advance!