Name | Item |
John | apples |
Mary | oranges |
Bob | grapes |
Sue | oranges |
John | oranges |
John | lemon |
John | celery |
Mary | grapes |
Bob | oranges |
Sue | celery |
John | apples,oranges,lemon,celery |
Mary | oranges,grapes |
Bob | grapes,oranges, |
Sue | oranges,celery |
<colgroup><col><col></colgroup><tbody>
</tbody>
I have a spreadsheet in which I need to combine items listed in several different rows but belong to the same person. Can someone assist in getting on output as I show below? thank you in advance