Rearrange tables

Hello,

In the added file there is two tables.
The data in both of the tables is the same.
The diffrence is that evry value in the cells of table 1 is a full row in table 2.
I have lots of data that arrange in tables as table 1 and I need to arrange it in one big table as table 2.

Is there a way to do it without programing?
If not where can I do it?

Thanks
try4.xlsx

Hi,
May be with pivot table by using wizard
First make a PT_Transfert with Table 1
Extract a basic table (double click on value then make the final pivot table and rearrange fields
Note : there is an error on your Table 2 : type is A for 4 rows, then B, C, and D
Hope this helps
Best regards