trying to split data from 1 row into two separate rows, then copy and paste
the function(s) without skipping rows. i don't know how to word it better,
but here is my problem:

a b c d e f g h i j k
1 xyz 200 5.8 xyz 200 5.2 xyz 200 5.8
2 abc 400 10.6 abc 400 10.1 xyz 200 5.2
3 lmn 300 4.5 lmn 300 4.8 abc 400 10.6
4 qrs 500 8.7 qrs 500 9.5 abc 400 10.1
....

i want to copy data from row "1" from columns "a:c" into row "1" columns
"i:k" and then copy data from row "1" from columns "e:g" into row "2" columns
"i:k"...

finally, i would like to copy and paste the "i:k" columns downwards.

when i tried to do this with copy and paste, it would skip the data from
every other row.

sorry, i can't be more clear. hope someone can help. thanks in advance.