How do I move data from specific rows of a column into another column?

[djp979]

The csv files that I pull are not formatted properly, something like this..

Ideally, I'd like to move data from row 7 to 11 to new columns, then remove first row to look like this..

Is there a way to do this?

[vanessafvg]

can you share some data in text format?

[djp979]

a,b,c,d,e
,first,second,third,fourth
L,8,-2,4,6
C,9,-4,2,7
R,7,-5,3,7
,,,,
a2,b2,c2,d2
,first(2),second(2),third(2)
L,4,-3,5
C,7,0,3
R,2,-1,3