Dear all
I've spent some time trying myself but I feel it's time I ask really smart people here
My challenge is: i have 350 people in excel in the following format (7 columns )
[TABLE="width: 564"]
<colgroup><col span="7"><col></colgroup><tbody>[TR]
[TD][TABLE="width: 564"]
<colgroup><col span="7"><col></colgroup><tbody>[TR]
[TD]var1[/TD]
[TD]1[/TD]
[TD]detail1[/TD]
[TD]1127,23[/TD]
[TD]add1[/TD]
[TD="align: right"]3444[/TD]
[TD]NAME[/TD]
[TD]1. JOHN DOE[/TD]
[/TR]
[TR]
[TD]var2[/TD]
[TD]8100[/TD]
[TD]detail2[/TD]
[TD]7094,7[/TD]
[TD]add2[/TD]
[TD="align: right"]2351[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var3[/TD]
[TD]80[/TD]
[TD]detail3[/TD]
[TD]638,52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var4[/TD]
[TD]6480[/TD]
[TD]detail4[/TD]
[TD]111,25[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5[/TD]
[TD]1620[/TD]
[TD]detail5[/TD]
[TD]2795,79[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var6[/TD]
[TD]69[/TD]
[TD]detail6[/TD]
[TD]46,33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var7[/TD]
[TD]69[/TD]
[TD]detail7[/TD]
[TD]158[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var8[/TD]
[TD]50[/TD]
[TD]detail8[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var9[/TD]
[TD]50[/TD]
[TD]detail9[/TD]
[TD]150[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var10[/TD]
[TD]2,93[/TD]
[TD]detail10[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var11[/TD]
[TD]234[/TD]
[TD]detail11[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var12[/TD]
[TD]1[/TD]
[TD]detail12[/TD]
[TD]145[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var13[/TD]
[TD]34[/TD]
[TD]detail13[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var14[/TD]
[TD]4[/TD]
[TD]detail14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var15[/TD]
[TD]123[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var16[/TD]
[TD]423[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var17[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var18[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var19[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var20[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var1[/TD]
[TD]1[/TD]
[TD]detail1[/TD]
[TD]1127,23[/TD]
[TD]add1[/TD]
[TD="align: right"]3444[/TD]
[TD]NAME[/TD]
[TD]2. JANE DOE[/TD]
[/TR]
[TR]
[TD]var2[/TD]
[TD]8100[/TD]
[TD]detail2[/TD]
[TD]7094,7[/TD]
[TD]add2[/TD]
[TD="align: right"]2351[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var3[/TD]
[TD]80[/TD]
[TD]detail3[/TD]
[TD]638,52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var4[/TD]
[TD]6480[/TD]
[TD]detail4[/TD]
[TD]111,25[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5[/TD]
[TD]1620[/TD]
[TD]detail5[/TD]
[TD]2795,79[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5.1[/TD]
[TD]322[/TD]
[TD]detail6[/TD]
[TD]46,33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5.2[/TD]
[TD]23[/TD]
[TD]detail7[/TD]
[TD]158[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var6[/TD]
[TD]69[/TD]
[TD]detail8[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var7[/TD]
[TD]69[/TD]
[TD]detail9[/TD]
[TD]150[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var8[/TD]
[TD]50[/TD]
[TD]detail10[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var9[/TD]
[TD]50[/TD]
[TD]detail11[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var10[/TD]
[TD]2,93[/TD]
[TD]detail12[/TD]
[TD]145[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var11[/TD]
[TD]234[/TD]
[TD]detail13[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var12[/TD]
[TD]1[/TD]
[TD]detail14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var13[/TD]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var14[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var15[/TD]
[TD]123[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var16[/TD]
[TD]423[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var17[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var18[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var19[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var20[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
what I want to get out is table with headers:
NAME var1 var2 var3 var5 detail 3
JOHN DOE 1 8100 80 1620 638,52
JANE DOE....
..
..
I've spent some time trying myself but I feel it's time I ask really smart people here
My challenge is: i have 350 people in excel in the following format (7 columns )
[TABLE="width: 564"]
<colgroup><col span="7"><col></colgroup><tbody>[TR]
[TD][TABLE="width: 564"]
<colgroup><col span="7"><col></colgroup><tbody>[TR]
[TD]var1[/TD]
[TD]1[/TD]
[TD]detail1[/TD]
[TD]1127,23[/TD]
[TD]add1[/TD]
[TD="align: right"]3444[/TD]
[TD]NAME[/TD]
[TD]1. JOHN DOE[/TD]
[/TR]
[TR]
[TD]var2[/TD]
[TD]8100[/TD]
[TD]detail2[/TD]
[TD]7094,7[/TD]
[TD]add2[/TD]
[TD="align: right"]2351[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var3[/TD]
[TD]80[/TD]
[TD]detail3[/TD]
[TD]638,52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var4[/TD]
[TD]6480[/TD]
[TD]detail4[/TD]
[TD]111,25[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5[/TD]
[TD]1620[/TD]
[TD]detail5[/TD]
[TD]2795,79[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var6[/TD]
[TD]69[/TD]
[TD]detail6[/TD]
[TD]46,33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var7[/TD]
[TD]69[/TD]
[TD]detail7[/TD]
[TD]158[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var8[/TD]
[TD]50[/TD]
[TD]detail8[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var9[/TD]
[TD]50[/TD]
[TD]detail9[/TD]
[TD]150[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var10[/TD]
[TD]2,93[/TD]
[TD]detail10[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var11[/TD]
[TD]234[/TD]
[TD]detail11[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var12[/TD]
[TD]1[/TD]
[TD]detail12[/TD]
[TD]145[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var13[/TD]
[TD]34[/TD]
[TD]detail13[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var14[/TD]
[TD]4[/TD]
[TD]detail14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var15[/TD]
[TD]123[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var16[/TD]
[TD]423[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var17[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var18[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var19[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var20[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var1[/TD]
[TD]1[/TD]
[TD]detail1[/TD]
[TD]1127,23[/TD]
[TD]add1[/TD]
[TD="align: right"]3444[/TD]
[TD]NAME[/TD]
[TD]2. JANE DOE[/TD]
[/TR]
[TR]
[TD]var2[/TD]
[TD]8100[/TD]
[TD]detail2[/TD]
[TD]7094,7[/TD]
[TD]add2[/TD]
[TD="align: right"]2351[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var3[/TD]
[TD]80[/TD]
[TD]detail3[/TD]
[TD]638,52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var4[/TD]
[TD]6480[/TD]
[TD]detail4[/TD]
[TD]111,25[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5[/TD]
[TD]1620[/TD]
[TD]detail5[/TD]
[TD]2795,79[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5.1[/TD]
[TD]322[/TD]
[TD]detail6[/TD]
[TD]46,33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var5.2[/TD]
[TD]23[/TD]
[TD]detail7[/TD]
[TD]158[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var6[/TD]
[TD]69[/TD]
[TD]detail8[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var7[/TD]
[TD]69[/TD]
[TD]detail9[/TD]
[TD]150[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var8[/TD]
[TD]50[/TD]
[TD]detail10[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var9[/TD]
[TD]50[/TD]
[TD]detail11[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var10[/TD]
[TD]2,93[/TD]
[TD]detail12[/TD]
[TD]145[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var11[/TD]
[TD]234[/TD]
[TD]detail13[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var12[/TD]
[TD]1[/TD]
[TD]detail14[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var13[/TD]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var14[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var15[/TD]
[TD]123[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var16[/TD]
[TD]423[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var17[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var18[/TD]
[TD]34[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var19[/TD]
[TD]23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]var20[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
what I want to get out is table with headers:
NAME var1 var2 var3 var5 detail 3
JOHN DOE 1 8100 80 1620 638,52
JANE DOE....
..
..