I mean, how can I get from this:







a result like this:



This means I have a table and need the headlines (ACE) to be above the value lines (BDF). So the merge should skip a line then merge and then the same role should apply to the second and fourth rows, etc. The file is over a million row, sadly. Thank you in advance.

  • by using macro. – Rakesh Shewale Jul 23 '15 at 13:37
  • I tried, it just delete the rows. – user472550 Jul 23 '15 at 13:45
  • Share your macro so we can see and help – Dave Jul 23 '15 at 13:58
  • I would, but I can't step into it. It's quite strange, that is so different from Ecxel. I only can recond and then save and reply. No editing mode :(. – user472550 Jul 23 '15 at 14:15
  • No, I read that, and do not work for me. As that one do not skip rows and mine would. I tried to build it to skip one row before merge but it do not work out. – user472550 Jul 23 '15 at 14:30

I would break my objective in two tasks: 1. Form ACE... 2. Form BDF...

To form ACE.., record a macro and do following in sequence

Home Shift End Right arrow Ctrl + X Down arrow Ctrl + V Backspace

Repeat this until required.

This will complete your first task and the result will be the last line of the file..

To form BDF.. It is more simple. point your cursor at B and Record macro:

End Delete

Repeat till you reach result of the first task..

That's it :)


CTRL-j is the shortcut key to merge two lines. You can record a macro to go to the next line, select, down arrow, CTRL-J, down arrow.

Then you can run the macro multiple times to merge a bunch. It's not elegant, but it gets the job done.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy