Macro to Duplicate Line + Transpose Data

[flarel]

Hi everyone,

i really need your help, please.

i have data:
A1 = Rick |x| B1 = 2 |x| C1 = 3 |x| D1 = 4 |x| E1 = 5 |x| F1 = 6
A2 = John |x| B2 = 11 |x| C2 = 12 |x| D2 = 13 |x| E2 = 14 |x| F2 = 15

How can i make it into:
A1 = Rick |x| B1 = 2
A2 = Rick |x| B2 = 3
A3 = Rick |x| B3 = 4
A4 = Rick |x| B4 = 5
A5 = Rick |x| B5 = 6
A6 = John |x| B6 = 11
A7 = John |x| B7 = 12
A8 = John |x| B8 = 13
A9 = John |x| B9 = 14
A10 = John |x| B10 = 15

It is simple but if i have more than thousand data, it's really tiring.

Anyone can help me to create the macro?

I really appreciate your help.
Thanks before.

[nilem]

Hi Flarel, try it

Please Login or Register  to view this content.