how to transpose a table?

Hello,  I do have a table created and would like to transpose the data.  Similar is done in Excel.  Thank you

Best Answer

  • AdamT



    Answer ✓

    Hi @leoper - There is a really handy feature to do exactly this in Magic ETL called "Collapse Columns". Give that a try. If you need any help, feel free to reach out!

    I work for Domo.
    **Say "Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as "Accepted Solution"


  • Hi all,


    Can anybody help @leoper with their question?


  • Hey Adam, I saw your post here can you direct me on the steps to transpose a table. I tried "Collapse Columns" but it didnt appear to work in the way that i was expecting.  Could we connect sometime to figure this out?

This discussion has been closed.