Arrange datas to Transpose mode.How ?

[PRADEEPB270]

I have a excel file and there are around 130 Matl.Group.like-A,B and C

Now ,I want to arrange data as shown in my attachment file.

There are 4 category i.e.Production,DOM Sales,Export Sales and Cap. and mnt from Apr to Mar.

I want to arrange my data 'month wise,Matl Group and Category wise"as shown in yellow colour.

Can it be possible through VBA or excel formula ? How ?