Hello Users,
Please help with data transformation.

The current data format:
sub-var1 sub-var2 sub-var3
var1 2 5 7
var2 9 10 6
var3 3 8 1
sub-var4 sub-var5 sub-var6
var4 0 4 7

I want to transform them into:

var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12
2 5 7 9 10 6 3 8 1 0 4 7

Thank you very much.
Lynn