Create a single product record from multiple lines of data for the same product

My next one seems trickier. I have a Sales data sheet with multiple lines of different data for the same products. A new line is created for any difference in sales variable (Annoyingly) for instance. lets say
Line 1: Product 1, 10 sold, on Domain#1, for £5.99
Line 2: Product 1, 3 sold, on Domain#1, for £2.99
Line 3: Product 1, 5 sold, on Domain#2, for £5.99, with 10% discount
Line 4: Product 2, 9 sold, on Domain#2, for £5.99, with 20% discount
Line 4: Product 2, 3 sold, on Domain#1, for £9.99, with 10% discount

Is there any way to create a single record for each product with all the variables?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.