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 Member
    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!

Answers

  • kshah008
    kshah008 Contributor

    Hi all,

     

    Can anybody help @leoper with their question?

    Thanks!

  • AdamT
    AdamT Member
    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!

  • 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.