Hi, I just need help. I need to copy the contents of vertical cells into a single cell.
BJ23 TO BJ33 is to be copied to B260
BJ34 TO BJ44 is to be copied to B271
BJ45 TO BJ55 is to be copied to B282
BJ56 TO BJ66 is to be copied to B293
BJ67 TO BJ77 is to be copied to B304
BJ78 TO BJ88 is to be copied to B315
BJ89 TO BJ99 is to be copied to B326
BJ100 TO B110 is to be copied to B337
BJ110 TO B121 is to be copied to B348
BJ122 TO B132 is to be copied to B359
BJ133 TO B143 is to be copied to B370
BJ144 TO B154 is to be copied to B381
BJ155 TO B165 is to be copied to B392
How can I copy it into a single cell “as is” 1 below the other (vertically)? Can I do this without using macro or VB? Anybody please. Thanks in advance.
(Please see attached zipped excel file)
Bookmarks