Hi all,

I have data like this

q c q c q c q c
a 1 10 2 20 3 30 4 40
b 5 50 6 60 7 70 8 80

I want to arrange the above data as follows:

a 1 2 3 4
10 20 30 40
b 5 6 7 8
50 60 70 80

That is a row has to be inserted, and alternative col data has to be
included and has to be deleted

I have lot of data like this in the format shown. I have to change it to the
new format
how can i do tihis?