Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following table and trying to merge it:         value1         value2         value3         value4         value5         value6         value7

How do I convert into this without using macros, just simple excel functions please.         value1, value2         value3, value4, value5         value6,value7

Many thanks


migration rejected from 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… 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