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

Question

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

NameEmailQ1Q2Q3Q4Q5John Smith123515@anoynmous.comTrue    John Smith13463463@anoynmous.com A   John Smith24314534@anoynmous.com  C  John Smith1235623@anoynmous.com   B John Smith72563@anoynmous.com    D

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

NameEmailQ1Q2Q3Q4Q5John Smith TrueACBD

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.

Qiu · Answer

@rmartori

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

0120-rmartori.yxmd

Christine_Assaad · Answer

@DannyS , I like the fewer tools WF!

Christine_Assaad · Answer

Hi @rmartori

Please check the attached. Hope it helps.

Merge rows and columns.yxmd