Copy information from table to table

[yanivp1]

Hello everyone,


I will appreciate so much an answer to my comlpicated question:
Which formula should I put that will enable me to copy the information from table 1 to table 2 as shown at the attached screen shot?

Thanks a lot,
Yaniv.
https://mhtramla-my.sharepoint.com/...klqZSSzNEw&e=c5d1a43c17044af28540b3c6c816f208

 

[yanivp1]

A link to the file:
https://mhtramla-my.sharepoint.com/...t7qAVMoNaQ&e=e5f5ef115cfc401e8fcb017344e9f2ab

 

[yanivp1]

Thanks for reading the post, but I got the answer and don't need an help.