Help

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

524 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rob_Tucker
4 - Data Explorer
4 - Data Explorer

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?

0 Replies 0