Error with folder option for merge columns

[Anonymous]

Hi everyone,

I have two columns from a source folder option. In the first column, I want these rows to become columns and my values ​​in the second column to become rows. The difficulty being that instead of merging my identical rows, it would create duplicate columns for me. I'm a bit stuck if someone knows a solution .. I should only have 13 columns in the end.From column 14, the second file begins. You can see that columns 1 and 14 are identical.

Thank you guys 🙂

[danextian]

Hi @Anonymous 

Can you post a sample data that we can copy-paste please?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Help-needed-to-transform-data-via-M/m-p/20469#M6182