Matrix showing only First and Last values, not matches

[erictf]

I have a visual table and want this table turns into a "pivot table". I'm using a matrix to do this, however, some fields are showing the first and last entries of the data and not the matching entries as the table.

Here a screenshot.

But this is happening only with those values "Des FR" and "Des EN", the other values are matching correctly.

Any solution or workaround this, would be very appreciated.

Thank you.

[Daniel29195]

Hello , @erictf 

does the data has duplication of data for this specific part number ? 

this could be a reason .

if not, can you share the file to take a closer look at it .

best regards,,

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠