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?
