Hi @Aina- ,
You need to use pivot first and then unpivot.
1.Select the two columns and then click "Unpivot other columns".
2.Split the Attribute column with " ".
3.Select the Attribute.1 column and click Pivot Column.
Now you have a column with month name, a column with QTY and a column with VAL.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.