I am in the transport industry and I have a master data sheet which shows every single load that was done and every drop on each load. So in the data sheet, load numbers can be duplicated depending on how many drops exist on that load.
I need to create a seperate table from the master that I can use to analyse at trip leave (ie per load).
To do this I need a column in the new table with all the unique load numbers (without duplicates) and I need the rest of the columns to reference the load number and provide the assocaited value.
I tried using the "lookupvalue" function but it doesnt work when there are multiple values linked to the reference (load number).
So ideally in that situation I need to column to show the first value associated with that load number.