Excel macro (need help)

Joined
Jun 22, 2013
Messages
1
Reaction score
0
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?
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top