Copy Values VBA

[Oprichnick]

Hello,
I need to transform a table like table 1 in a table 2.

I need to do this in a very repetitive way. Each calculation output is something like Table 1 and in fact I need the data in a Table 2 format.

Honestly I don't have many clues in how to do it.

Table 1
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]x[/TD]
[TD="align: center"]y[/TD]
[TD="align: center"]z[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]b[/TD]
[TD="align: center"]c[/TD]
[/TR]
[TR]
[TD="align: center"]aaa[/TD]
[TD="align: center"]bbb[/TD]
[TD="align: center"]ccc[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]

Table2

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]x[/TD]
[TD="align: center"]y[/TD]
[TD="align: center"]z[/TD]
[TD="align: center"].....[/TD]
[TD="align: center"]nº[/TD]
[/TR]
[TR]
[TD="align: center"]aaa[/TD]
[TD="align: center"]bbb[/TD]
[TD="align: center"]ccc[/TD]
[TD="align: center"]a[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]aaa[/TD]
[TD="align: center"]bbb[/TD]
[TD="align: center"]ccc[/TD]
[TD="align: center"]b[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]

Regards

 

[Joe4]

I think you will need to explain the logic how you get from Table1 to Table2.