Combining text fields for duplicate records

[lwilt]

If I have a table that looks like:

email	customer 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>

999@yahoo.com 1005 Y

How can I combine the responses so that there isn't any duplicate emails and the responses all get combined under each of the questions so I don't lose any of the responses? There would be 17 total questions I would be trying to combine for the dup emails if that matters.

 

[lwilt]

I'm assuming the only way to do this is through a macro

 

[West Man]

Assuming your data is in sheet1 A1:F9, copy column A into sheet2 and remove duplicates (remove duplicates on the data tab) insert headings
In C2 and copied down and across =IF(COUNTIFS(Sheet1!$A$2:$A$9,Sheet2!$A2,Sheet1!C$2:C$9,"Y")>0,"Y","")

email		apples	trees	sports	ice cream
abc@yahoo.com		Y	Y		Y
123@gmail.com		Y	Y	Y
owow@yahoo.com		Y
999@yahoo.com		Y		Y	Y

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

 

[lwilt]

That didn't seem to do anything...

 

[West Man]

What I posted was the results I got from your sample data Did you adjust your sheet names and ranges?

 

[lwilt]

My bad...when typing the formula I left out the part where you searching sheet one for the email before checking the respones. worked great thank you.

Is there a way you can drag the formula to the right and have it update the columns? So at each new column you drag it to the C in the last part of the formula gets updated to D, E F, ect.

 

[lwilt]

nevermind stupid question lol

 

[West Man]

Glad it worked for you.