Well, if you want to have your list based on ID, here it’s
but at the end: do you want to have in your final list (my jl_Final List column) the same sequence/order showed in your 2nd table? It’s quite difficult!
If you are going to create a chart based on fruit ID’s qty, I don’t see the problem with my jl_Final List column? The order in the list doesn’t matter. 
Saludos Darren