Excel macro (need help)

[nurali2002]

I want to do some work with macro. Actually i have an sheet like this:

___A1 ____ ___ B1____ _____ C1_____ D1_____ E1 __________ F1 _______________G1 ___________H1
1 jjjjjjjj ______QQQQQ ____ KKKKK___ LLLL ____MMMM___ NNNNNN

2

3

4

5 HHHH ______JJJJJJ _______ KKKK _____QQQQ ____ YYYY________ ZZZZZ______ LLLLLL ________mmmmmm

6

7

9

10

11

12 continue many row like this


I want to past spesial transpose after E1 and my output need to like below


_____A1________ B1 _____ C1 _______ D1 ______E1 ______F1 ______G1________ H1
1 ___ jjjjjjjj ____ QQQQQ __KKKKK

2______________________ LLLL

3______________________ MMMM

4 ______________________ NNNNNN

5_ HHHH ______JJJJJJ ___ KKKK

6 _____________________ QQQQ

7 ______________________YYYY

9_____________________ ZZZZZ

10 ___________________ LLLLLL

11____________________ mmmmmm


There are more row like this so how can i do this process by macro or any system?