Expend table to create subcategories

Lara Member



How can I transform my table 1 to the format of table 2 ( as seen in the attached docment)

I am doing it with magic ETL by maping values and then replacing it the first column , but it takes a lot of time!

I hoped there would be a more efficient way of doing it.  Any suggestions?


Thank you!


  • Hi,
    Anyone help out with this request?


  • shummer
    shummer Domo Employee

    Hey Lara,


    You may want to try the uncollapse columns feature in ETL. You can find more information about that here:  https://knowledge.domo.com?cid=etlactionseditcolumns


    The Uncollapse Columns action lets you "pivot" or de-normalize data in tables using key-value pairs, transforming a single column with multiple rows into multiple columns in a single row. 


    Hopefully, that's helpful!