Chart sort data issue
 

so I have data is some columns that looks almost like this:

N95 N95 8GB E65
blah1 blah2 XXX

N95 6120 6300
some XXX some2

I hope you can imagine this in cells :) and ofcoruse more and more data,
in some cases as you can see there is 2 times N95 and under the models there
are results that could also mach (for instance 2 tiems XXX)
I need to create a chart that should take the data from these fields and
give me the result with the most recent unit that it can find in the cells,
for instance if there are 6 cells with N95 and 3 cells with XXX
it should give me a chart starting with N95 (rising to 6 in this case) then
N95 8GB (rising to #) etc.
and probably another chart that should work the same way but the result
should be the data (XXX or whatever is the most recent data in the cells)

I do not really need the chart to be combined with results based on type and
data since I can easily select them separatedly and simply make two separated
charts.

I hope someone can give me tips on how to do it cause I am really out of
guesses.

Thank you :)