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