LOOK UP VALUE WITH MULTIPLE RESULTS

[MoumouhElRebeld]

Hi

I have a table with hudred thousands lines structured as below

DATE               CAR REF         MOVE
01.01.2022      RNTX1            Entered

08.03.2022      RNTX1            Entered

15.08.2021      RNTX2            Get Out

22.02.2022      RNTX1            Get Out

20.02.2022      RNTX1            Fixed

....

There is dates from 01.01.2018 till today

There is a incalculable number of CAR REFERENCE

There is 3 possible MOVES : Entered / Fixed / Get Out

My goal is to create a table based on dates like below knowing that the CAR REF is doing the rount trip hundered times

CAR REF        ENTERED        FIXED                GET OUT

RNTX1          01.01.2022      20.02.2022         22.02.2022

RNTX2          .....                    ....                       ....

....                  .....                    ....                       ....

RNTX1          ....                     ....                       ....

.....

[DataStraine]

Based on your request, it appears all you need to do is create a matrix visualization with the data and ensure that your data model is connected correctly. Without more information about what you are exactly trying to create though I don't know if we can help you more than that.