Transformation for this table type

[chinaik123]

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.

[ryan_mayu]

@chinaik123 

in PQ, you can try to select the first column and unpivot other columns

Unpivot columns - Power Query | Microsoft Learn

[chinaik123]

Hi @ryan_mayu,

I tried to Unpivot but it does not look like i can use this format

Thanks,

Ricky

[ryan_mayu]

@chinaik123 

select first column and unpivot other columns

you should get below output

pls see the attachment below

[chinaik123]

Hi @ryan_mayu ,

I am able to do it if my Jan - April column does not include date.

But when i include date like Jan 2023, it does not work already.

[ryan_mayu]

could you pls sample data and what's the expected output? Since I didn't see year info in the screenshot you provided.

[chinaik123]

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 

[ryan_mayu · Accepted solution]

@chinaik123 

you can do the same say

then you can split the column to get year and month

pls see the attachment below

[chinaik123]

Thank you! I found out why I am not able to do that, cause I did not use my first rows as header. After doing that, I am able to convert it. Thanks!

[ryan_mayu]

you are welcome