Combining text fields for duplicate records

[lwilt]

if I had a table that looks like:

[TABLE="width: 351"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]email[/TD]
[TD]custome number[/TD]
[TD] apples [/TD]
[TD]trees [/TD]
[TD]sports [/TD]
[TD]ice cream[/TD]
[/TR]
[TR]
[TD]abc@yahoo.com[/TD]
[TD="align: right"]123[/TD]
[TD] Y[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]abc@yahoo.com[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123@gmail.com[/TD]
[TD="align: right"]858[/TD]
[TD] Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123@gmail.com[/TD]
[TD="align: right"]767[/TD]
[TD][/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]owow@yahoo.com[/TD]
[TD="align: right"]444[/TD]
[TD] Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]owow@yahoo.com[/TD]
[TD="align: right"]455[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]999@yahoo.com[/TD]
[TD="align: right"]1001[/TD]
[TD] Y[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]999@yahoo.com[/TD]
[TD="align: right"]1103[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Is there a way in access to combine the responses so that each email has the 4 answers combined into their own seperate fields that way there isn't dup emails and I don't lose any of the responses?

 

[Micron]

If you're suggesting poster does this in Excel, then I understand. Otherwise, he's posting in the Access part of the forum and I don't.

 

[lwilt]

Would I need to make any changes to it since I would ultimatly have 17 Columns instead of the 4 he had in his