Okay, I have worked myself into a corner.
I have created 6 dynamic lists, and now need to combine them into a single list, with no spaces or gaps.
I have 26 dock doors (numbered 1 - 26). Due to construction, only certain number of doors can be used at one time. And this can, and does, change with each delivery run. Each door is assigned a delivery route.
There are 6 Delivery runs per day using any of the 26 dock doors.
The dynamic lists are the delivery run summaries. This route to this door... That door not used... etc.
This was done with simple Sort based on cell values.
Now I need a single list, or summary, of the 6 individual lists that can be used as a master list.
Any help would be appreciated
I have created 6 dynamic lists, and now need to combine them into a single list, with no spaces or gaps.
I have 26 dock doors (numbered 1 - 26). Due to construction, only certain number of doors can be used at one time. And this can, and does, change with each delivery run. Each door is assigned a delivery route.
There are 6 Delivery runs per day using any of the 26 dock doors.
The dynamic lists are the delivery run summaries. This route to this door... That door not used... etc.
This was done with simple Sort based on cell values.
Now I need a single list, or summary, of the 6 individual lists that can be used as a master list.
Any help would be appreciated