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 |
Solved! Go to Solution.
@gawa thank you for the quick solution.
@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 |
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.