We want to set up a pivot table that enable to mix two databases into a third that extract the data by the way of a unique key of each of the lines from the 2 first databases.
Data will be entered manually into the sheet in red.
The pivot table is in black.
In the pivot table only the ID for USER and ASSET will be entered in a mixed way.
Please find details here of the specification: https://docs.google.com/presentation/d/16AnSzPLcblBTV1k2qSg4iFcFtLiShyjGFwzynvodeZs/edit#slide=id.g3da0259b73_0_1
Example of a pivot table here of the deliverable: