how can rearrange data in excel

[postingart003]

have table in this formate
1.png
i want result in this formate

2.png
i have huge row of data , i can do one by one any one can help me to show data in this formate
thanks dear

[JeteMc]

Hello postingart003 and Welcome to Excel Forum.
This proposal employs Power Query, which is a free add in from Microsoft for the 2010 version of Excel.
The blue table represents your actual table.
The green table is produced using the following advanced editor code in power query:

Please Login or Register  to view this content.

The range L1:N22 is produced using: =IF($H1="Total","",G1)
Let us know if you have any questions.