Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

182 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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