Data Manipulation (Adding column data into rows)

[sandubandu]

Hi I have attached both existing and required data structure in the attached file,
I am not able explain what exactly I want, Please check attached file, its pretty much self explanatory.
I am looking for a shortcut or formulas to do this task.

Thanks you.

[Estevaoba]

Try in J4 and copied down

Please Login or Register  to view this content.

in K4 copied across to M4 and down:

Please Login or Register  to view this content.

in N4 and copied down:

Please Login or Register  to view this content.

Please check file attached.

Good luck!