Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following table and trying to merge it:

email1@mail.com         value1
email1@mail.com         value2
email2@mail.com         value3
email2@mail.com         value4
email2@mail.com         value5
email3@mail.com         value6
email3@mail.com         value7

How do I convert into this without using macros, just simple excel functions please.

email1@mail.com         value1, value2
email2@mail.com         value3, value4, value5
email3@mail.com         value6,value7

Many thanks


migration rejected from stackoverflow.com Jun 23 '13 at 10:21

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off topic by Sathya Jun 23 '13 at 10:21

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here. If this question can be reworded to fit the rules in the help center, please edit the question.

Consolidate or Pivot (look up help or google it) can do somewhat similar things but doing exactly the above can be done only by scripting, as you are not about to summarize values or manipulate them on any other way, but you want (kind of) merge cells which is -as far as I know- not supported this way –  Mark Jun 21 '13 at 12:43
stackoverflow.com/questions/17240052/… answers for both vba and non-vba provided –  xQbert Jun 21 '13 at 17:10
You should add a vba tag to your question if you want code answer. If you want Excel application feature, it is probably offtopic here. –  Jan Turoň Jun 22 '13 at 13:21