How to group the data correctly so that you can then create a pivot based on it?

Question

excel

There is data:

• Employee name
  
• Prof. skills
  
• Projects for which he works
  
• Allocation on each project (involvement in the project as a percentage)
  

It is necessary to create 2 tables:
1) A table with general information about an employee
2) Shows information grouped by projects in the order: Project Name / People Allocation / Employee Name / Prof. skills

How to create the first table so that it can be used to create the second one? Namely, he is interested in how to write down projects and allocations that relate to a specific person.