Hello everyone,
Thanks for your help in advance (this is my first post).

I am needing help taking information from one table and putting it in another table. Below is a simple example of what I need.

Screen Shot 2018-08-29 at 3.52.41 PM.png

FIRST, I need to find the dates in the first chart that correspond with an (L).
I need this to populate in the second chart under "Date". The issue is, I don't want spaces AND I want to allow for DUPLICATE Dates (as seen in this example for "4/1/18".)

SECOND, I need the fruit I loved from the first chart to populate next to the correct date in the second chart under "Fruit". However, because there were two fruits I ate on the same day and loved them both, I need both 4/1/18 to populate with different fruit.

Does this make sense? Sorry, not good at explaining.