Magic ETL equivialent to "Group" in excel



If I have an excel sheet with grouped columns in multiple layers as in the screenshot:

Food is the big category ( that is the total of the others) , food at home is a sub category (total of the others) etc..

Is there a way to re-devide the data that way in domo? 


Thank you!