sum the price

[Sshasnk]

Hi I have a dataset that I have to check with the average price to the column F2

Input: 

Fruit	F2	Price
Apple	average price: 10
		15
		13
Mango	average price:12
		12
Banana	average price: 8
		10
		5
		15

Output:

Fruit		Price
Apple	average price: 10	14
Mango	average price: 12	12
Banana	average price: 8	10

[Qiu]

@Sshasnk 
We need first assign the "Group" using a Multi-Row Formula tool then calculate the average with a summarize tool.

[Sebastiaandb]

hI @Sshasnk 

Here you go!

[Sebastiaandb]

Of course, @Qiu  was faster ;-). 

[Qiu]

@Sebastiaandb 
Faster does not mean better. :)