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
    AdamT Domo Employee
    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"

Answers

  • kshah008
    kshah008 Contributor

    Hi all,

     

    Can anybody help @leoper with their question?

    Thanks!

  • AdamT
    AdamT Domo Employee
    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"
  • 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.