Hi,
Take a copy of your data using Copy Snap and use aggregate snap or Unique snap (to get single value for each combination) and join again with the matching column. But, the value will be picked up randomly except you have a logic to sort the data.
