Why not simply delete a column at left before your datarange? When you move all data to left a cell, all previous entries in this column are overwritten anyway!

Hi,

Thanks for the prompt reply.

I simply can't delete a column on the left as I am compiling data from left to right and I'm copying different range of cells that are staggered for example I have attached a spreadsheet as a very basic example of what I want to do, but I obviously will have many rows.

So essentially I want to re-align all the data (In this case ID numbers in Example.xlsx) in a single column without having to do it manually using the offset feature. Unless you have a better alternative??

Attached Files

Example.xlsx (9.0 KB, 9 views)