Unique sequencing

[srooney]

I have a data set that follows A1000-A1106. I'm sequencing for warehouse layouts, where you sequence down one aisle and up the next, e.g. A1000-A1106 even would have a sequence running down, A1001-1005 would run back up, so adding a sequence of say 1000 in cell 1, 1100 in cell 2, well it doesn't work as they both increase, one top to bottom, and the other bottom to top. I have quite a bit of data, so filtering is required. I've filtered by Odd, and by the Aisle, e.g. A, B, C, D...but I can't get this data in the cells without doing it manually now. I can't copy and paste the values due to the filters, so sort of lost right now.

 

[awoohaw]

welcome to the forum. Please post a small sample of your raw data, and a sample of what your expectations are.
The forum has a tool called xl2bb add in (link below) that allows you to do that. If not please post the data and expectations in TABLES and not an image.
Thanks in advance.