Views merge rows: merge uniques values and show the first one I'm using Views merge rows to grouping rows by some fields, It worked good for me, but in some fields I want to show just the first filled value that means: merge uniques values+use the first value.
View after using VMR

Orginal view

Is there a way to do that using views merge rows? or I have to use an other solution? 
Or how I can hide/remove rows which have cycle smaller than the max cycle value  for every every container -see the image above-? I couldn't do it with views filter.

I'll explain my use case below to show the purpose of creating this view:


  The objective was tracking the containers, so I have to show
  containers and there currents and previous places. The container
  pass by a number of positions (in depot, at port of delivery, at port
  of loading...) until being in the vessel( position: on board), or it
  can be in an exceptional position like "reformed". I called the
  passage through those positions from the start to the end a
  "cycle" If the container is on board we have to fill all
  information about previous positions in a form "bill of lading". What
  I did as solution, I created 3 content type : container,position,bill
  of lading. The position content type reference the container and
  contains a select list field "position container" and 10 field
  collection field, every field collection contains a specifics fields
  for  a single position. So for every node position, I fill the field
  container, I select "position container" , I fill the field collection
  fields corresponding to the position selected. For example if I
  created a new position for the container "blk001" in position "in
  depot", I fill the field collection fields "name depot" and "date in
  depot". For the bill of lading content type it reference the
  containers also, I redirect to it every time the node position is
  saved and "position container" is "on board". Now the challenge is
  providing a list of containers,with the current bill of lading "N°
  B/L", the current cycle and merging all the positions fields
  corresponding to this cycle.
Sure there is probably some way to do that with PHP or an advanced SQL query. I recommend looking at Views Aggregator Plus as it allows you to aggregrate over Views PHP values.

Views is a simple query builder. When you want to do something really really complex, it can be useful to try to do some business logic outside of the views admin ui.