LOOK UP VALUE WITH MULTIPLE RESULTS

Question

HiI have a table with hudred thousands lines structured as belowDATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CAR REF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MOVE01.01.2022&nbsp; &nbsp; &nbsp; RNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Entered08.03.2022&nbsp; &nbsp; &nbsp; RNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Entered15.08.2021&nbsp; &nbsp; &nbsp; RNTX2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Get Out22.02.2022&nbsp; &nbsp; &nbsp; RNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Get Out20.02.2022&nbsp; &nbsp; &nbsp; RNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fixed....&nbsp;There is dates from 01.01.2018 till todayThere is a&nbsp;incalculable number of CAR REFERENCEThere is 3 possible MOVES : Entered / Fixed / Get Out&nbsp;My goal is to create a table based on dates like below knowing that the CAR REF is doing the rount trip hundered timesCAR REF&nbsp; &nbsp; &nbsp; &nbsp; ENTERED&nbsp; &nbsp; &nbsp; &nbsp; FIXED&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GET OUTRNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01.01.2022&nbsp; &nbsp; &nbsp; 20.02.2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22.02.2022RNTX2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;........&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;....RNTX1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.........&nbsp;

datastraine · Answer

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.

Forum Discussion

LOOK UP VALUE WITH MULTIPLE RESULTS

1 Reply

Related content

Waterfall with multiple values

Text slicer: pasting multiple values

ISFILTERED multiple values

Slicer for Multiple-Choice Values

LOOKUPVALUE with multiple results