Combining text fields for duplicate records

[lwilt]

if I had a table that looks like:

email	custome number	apples	trees	sports	ice cream
abc@yahoo.com	123	Y	Y		Y
abc@yahoo.com	126
123@gmail.com	858	Y
123@gmail.com	767		Y	Y
owow@yahoo.com	444	Y
owow@yahoo.com	455
999@yahoo.com	1001	Y			Y
999@yahoo.com	1103			Y

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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