How do I edit my vba code so the datas will not be separated in 2 parts

[Firied]

How do I edit my vba code so the datas will not be separated in 2 parts like in the picture, The command is to make all the datas from column A,B,C,F,G,H to be in the same rolls not separated like this

​31675

[Aussiebear]

Welcome to VBAX Firied. Bit hard to say until you post your current code, or you post a sample workbook. Just looking at an image doesn't tell us much.

[Gasman]

This is the Access forum?