move every fourth line to next column

Hi there

I want to edit the excel file (301-310) that it looks like this one (151-160). So my plan is to move every 4th line to the right column and move it upwords, so the german word is next to the english one (like the file 151-160).

I've search the forum, but I am an hardcase nooby with excel and don't know anything about macros and that stuff.

Thank you very much for your help, I need this vocabs for my A-levels in germany. If something is unclear just ask me .


All the best
Robin

Assuming the structure is exactly as you show in your sample, add to the code module for the worksheet:

Please Login or Register  to view this content.

Simple code, easy to understand if you step through it.

Hello cytop

Thank you very very much for your fast reply. It works great ))

Wish you a great day!!
Robin