Your second example doesn't make sense. In Sheet1 row 2, for example, starting in column D, reading left to right:
21, 22, blank, 37, 38
but in Sheet2 row 2 starting in U, reading left to right
21, 22, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, 37, 38
It is completely unclear what is the pattern you are using to copy these numbers. Why have you added 13 extra blank cells?
Bookmarks