Magic ETL equivialent to "Group" in excel

Lara

Hi,

 

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! 

 

laura_igl

Hi,

Anyone can help out with this request?

 

Thanks,