How do I convert from wide to long format in the new magic ETL tool?

jchayes82
jchayes82 ⚪️
edited January 4 in Data Platform & Data Science

Hello all,

I found a tutorial instructing me how to convert from wide (e.g., 5 cols containing scores for different variables -- all on a 1 - 5 Likert scale) to long (e.g., all 5 cols aggregated into two cols --> one containing the variable name and the other containing the score). However, the tutorial is for the older version of the ETL tool which includes a "Collapse Columns" option. Is this option no longer available? If not, is there a workaround?

I would appreciate any feedback on this.

Kind regards,

-J

Tagged:

Categories