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!


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