Build a table

[max200560]

Hi guy. I need help to create a table. In this view I have for a car (Targa GB656HY) an exit on 11/01/21 to "Lenzi" and a back from "Lenzi" on 20/02/21. I would have this information on a row because I need to calculate tha difference between the two date. How can I transform this table to have data? I think if possible with a pivot but I've been using qlink for a few days.

[jwjackso]

Check Henric's Generic Load