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

x	y	z	a	b	c
aaa	bbb	ccc	1	0	3

<tbody>
</tbody>

Table2

x	y	z	.....	nº
aaa	bbb	ccc	a	1
aaa	bbb	ccc	b	3

<tbody>
</tbody>

Regards

 

[Joe4]

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