How to build a pivot table in Excel?

Question

Project management

It's not the first day I've been struggling with the problem of correctly building a report on resource congestion. The data is taken from the Project Server, based on which a pivot table (Figure 1) and a regular table (Figure 2) are formed. The problem is that you need to drag the columns "Number of hours per task per day" and "Capacity" into the rows of the pivot table, based on the date and resource name.

Figure 1

Figure 2

Figure 3

Answer 1

It seems to me that nothing will work. Conditional use of data from tables is possible according to one of the criteria. But if you have AND the date (rows) AND the name of the resources (columns) - then there will be trouble.