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 FruitsSales FruitsSalesApple100 Apple100Apple200 200Apple300 300Mango100 Mango100Mango300 300Orange20 Orange20Orange40 40Orange40 40Orange20 20

Merge cells output in excel using multi row tool

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

Developer

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

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

@gawa thank you for the quick solution.

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

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.