Combining multiple column values ( multiple rows) into single column values (single row)

hi Anonymous , your solution is possible if table 2 exist. But in this case table 2 does not exist ( just an expected outcome). 

Assuming i have this table in PBI, and i need an outcome so that in so called fruit2 column have combination of multiple fruits and also single fruits.