Error with folder option for merge columns

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 🙂