concatenate two cells by browsing a column

%3CLINGO-SUB%20id%3D%22lingo-sub-3365687%22%20slang%3D%22en-US%22%3Econcatenate%20two%20cells%20by%20browsing%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365687%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EI%20have%20a%20small%20question%20about%20the%20possibility%20of%20writing%20a%20formula.%3CBR%20%2F%3EI%20have%20a%20table%20with%20two%20columns.%20One%20with%20emails%20and%20the%20other%20with%20names%20of%20different%20events%20where%20people%20have%20registered.%3CBR%20%2F%3ESometimes%20there%20are%20two%20identical%20emails%20(same%20person%20who%20registered%20for%20two%20events)%2C%20so%20I%20would%20like%20to%20put%20this%20second%20event%20in%20the%20cell%20next%20to%20the%20first%20event%20on%20the%20same%20email%20address%20line.%3CBR%20%2F%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3365687%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3365841%22%20slang%3D%22en-US%22%3ERe%3A%20concatenate%20two%20cells%20by%20browsing%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388552%22%20target%3D%22_blank%22%3E%40gaellincker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20sample.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone,

I have a small question about the possibility of writing a formula.
I have a table with two columns. One with emails and the other with names of different events where people have registered.
Sometimes there are two identical emails (same person who registered for two events), so I would like to put this second event in the cell next to the first event on the same email address line.
Is this possible?

Thank you

1 Reply

@gaellincker 

Please see attached sample.