How would I merge multiple rows and columns based on duplicates in a name column

[rmartori]

So I have a quiz that the takers kind of messed up. they all took it anonymously which caused the below example issue.

Name	Email	Q1	Q2	Q3	Q4	Q5
John Smith	123515@anoynmous.com	True
John Smith	13463463@anoynmous.com		A
John Smith	24314534@anoynmous.com			C
John Smith	1235623@anoynmous.com				B
John Smith	72563@anoynmous.com					D

There are more names of course. But what I need it to look like by the end is:

Name	Email	Q1	Q2	Q3	Q4	Q5
John Smith		True	A	C	B	D

If there is a way to incorporate a Vlookup off of a different file as well I can possibly fill in the blank email but that isn't necessary.

Basically I need however many duplicates of each person collapsed along with all their answers.

[DannyS]

@rmartori 

Assuming you don't need that email column (which if you did you could easily add it to the summarize tool), this solution should do the trick for you!

Hope this helps.

[christine_assaad]

Hi @rmartori 

Please check the attached. Hope it helps.

[christine_assaad]

@DannyS , I like the fewer tools WF!

[Qiu]

@rmartori 

Similar to others, with addition of one more name and a formula tool for the email.