Rearrange data with vba

Maybe:

Please Login or Register  to view this content.

Thanks a lot!

The code copies the name to three rows below even if there is only two different start dates. That is a minor detail, however. I can make some code to delete redundant rows.

Unfortunately, I don't quite get how all the offsets work. Which parts would I need to revise if I have e.g. ten columns containing start dates instead of four?

Thanks in advance.

Try

Please Login or Register  to view this content.

I have no idea how to read your suggestion, Jindon, but it works like a charm :-)

I appreciate the contributions from both of you.