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??
|