Transposing the data

[Ekta]

Dear All, 

I am stuck at a point and need your advice or sample workflow for the issue please,

I am trying to transpose the data from Jan 19 to Dec 19 and i also need to get a seperate column with Grade which is a row above the month.

Output columns required are  - 

A | B | C | D | E | F | G | H | I | J | K | L | Months | Grade

Please help me with this, thank you so much in advance.

[Qiu]

@Ekta 

Sample Data Files for input and out would be helpful, not the picture.

[Ekta]

@Qiu , Thanks for the reply.. pls find the file attached.

Thank you in advance

[grazitti_sapna]

Hi @Ekta , give this a try and let me know if it works.

If this is what you are looking for kindly mark this post as solution.

Thanks.