[TABLE="width: 245"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]apples[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]grapes[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]lemon[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]celery[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]grapes[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]celery[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]apples,oranges,lemon,celery[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]oranges,grapes[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]grapes,oranges,[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]oranges,celery
[/TD]
[/TR]
</tbody>[/TABLE]
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
<colgroup><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]apples[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]grapes[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]lemon[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]celery[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]grapes[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]oranges[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]celery[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]apples,oranges,lemon,celery[/TD]
[/TR]
[TR]
[TD]Mary [/TD]
[TD]oranges,grapes[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]grapes,oranges,[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD]oranges,celery
[/TD]
[/TR]
</tbody>[/TABLE]
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