How to Loop through rows and Columns to Offset Data

Josh1012 · #3 09-06-2018, 01:31 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert rows when column A data changes then shade and autosum blanks in columns E to I	kgoosen	Excel Programming	0	08-30-2017 04:45 AM
Formatting data in scattered rows into rows following each other	MorneDJ	Excel	3	12-10-2016 12:35 AM
I cant get my Sum(Offset formula to pull appropriate data.	Erickd90	Excel	7	07-28-2016 12:20 PM
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Data validation list filter with range defined by OFFSET	Mango123	Excel	4	03-18-2014 02:52 PM