Forum Discussion
Transformation for this table type
Hi, I have a question. How would I be able to use this kind of tables to transform? I want to do a combination and make sure once i choose a metric, i can then transform to a chart easily. ...
Anonymous
you can do the same say
then you can split the column to get year and month
pls see the attachment below
could you pls sample data and what's the expected output? Since I didn't see year info in the screenshot you provided.
Hi ryan_maju,
Sorry, i change my sample to add in the year as i left out previously..
This is the sample and I am trying to get something similar to you. However, when i unpivot and do the same, it does not align well.
After I unpivot Other Columns i will recieve something like this