Merge cells output in excel using multi row tool

[Lumjing]

Hi I have the below data set and I want to achieve the output as below using multi row tool or any other method. can you please help

Input			Output
Fruits	Sales		Fruits	Sales
Apple	100		Apple	100
Apple	200			200
Apple	300			300
Mango	100		Mango	100
Mango	300			300
Orange	20		Orange	20
Orange	40			40
Orange	40			40
Orange	20			20

[gawa · Accepted solution]

hi @Lumjing 

As you mention, Multi Row Formula can be used like this.

[Lumjing]

@gawa thank you for the quick solution.

[Lumjing]

@gawa  can you help with the below. I have various combinations but not getting the requried output

Input			Output
Fruits	Sales		Fruits	Sales
Apple	100		Apple	100
Apple	200			200
Apple	300			300
Mango	100		Mango	100
Mango	300			300
Orange	20		Orange	20
Orange	40			40
Orange	40			40
Orange	20			20
Total	1120		Total	1120
Total	2140		Total	2140

[gawa]

hi @Lumjing 

You want to make an exception when Fruits="Total"? If so, please try this way.

Am I answering to your question? If you see I'm still not getting at your point, please let me know. I'll find another solution.