Andrew Susskind
New Member
Hey All,
I am an Account Manager in a Warehouse and have some questions about sorting data!! Alot of times I am taking all of the current data (SKU's, locations, Pieces availble) and trying to sort it for different reasons.
Today I am taking my data and just trying to sort through the current/relevant data for only my "A" locations.
My first step is taking my large portion of data and deleteing out all of the columns that are not important.
(here are all of the titles I am given right away)
UPC SKU BARCODE BIN DESCRIPTION COLOR SIZENO RECEIPT_CREDITS NON_RECEIPT_CREDITS SHIP_DEBITS NON_SHIP_DEBITS ONHAND ALLOCATED AVAILABLE RECENT_RECEIPT RECENT_CREDIT WHB_ID UPC_ID BIN_TYPE ALLOCATIONS_PICK ALLOCATIONS_CUSTOMER ALLOCATIONS_BLANKET WAREHOUSE
I am only going to be working with the below titles:
SKU BIN ONHAND ALLOCATED
AVAILABLE
For this specific example I am going to just work with my SKU's in my A locations.
My section of the warehouse is Isle 15-27
each isle is 13 row/bins long
and 4 columns high (A,B,C,D) A is the lowest location (pulling location)
I am wondering if there is a formula where I am able to take just the "A" locations.
But also once I have those "A" locations, if there is a way to insert a Space between each seperate Bin
for example:
If i have the following data
SKU BIN ONHAND ALLOCATED AVAILABLE
144-1-2154 16-01-A 73 0 73
281-0-6023 16-01-A 248 0 248
393-17P-7139 16-01-A 232 0 232
174-2-1269 16-02-A 126 45 81
396-3-2001 16-02-A 10 2 8
423-3-8351 16-02-A 303 2 301
803-3-2001 16-02-A 18 0 18
116-4-6442 16-03-A 79 1 78
254-4-5044 16-03-A 58 0 58
392-3-1191 16-03-A 3 0 3
859-2-1006 16-03-A 689 0 689
How can I take all of this data and efficently make it look like the following
144-1-2154 16-01-A 73 0 73
281-0-6023 16-01-A 248 0 248
393-17P-7139 16-01-A 232 0 232
174-2-1269 16-02-A 126 45 81
396-3-2001 16-02-A 10 2 8
423-3-8351 16-02-A 303 2 301
803-3-2001 16-02-A 18 0 18
116-4-6442 16-03-A 79 1 78
254-4-5044 16-03-A 58 0 58
392-3-1191 16-03-A 3 0 3
859-2-1006 16-03-A 689 0 689
See each bin is seperated, but all SKU's from that bin specifically are grouped together? Please let me know if you need me to explain this further, I am happy to attach a few more files that may give a better idea of what I am trying to accomplish!
I am an Account Manager in a Warehouse and have some questions about sorting data!! Alot of times I am taking all of the current data (SKU's, locations, Pieces availble) and trying to sort it for different reasons.
Today I am taking my data and just trying to sort through the current/relevant data for only my "A" locations.
My first step is taking my large portion of data and deleteing out all of the columns that are not important.
(here are all of the titles I am given right away)
UPC SKU BARCODE BIN DESCRIPTION COLOR SIZENO RECEIPT_CREDITS NON_RECEIPT_CREDITS SHIP_DEBITS NON_SHIP_DEBITS ONHAND ALLOCATED AVAILABLE RECENT_RECEIPT RECENT_CREDIT WHB_ID UPC_ID BIN_TYPE ALLOCATIONS_PICK ALLOCATIONS_CUSTOMER ALLOCATIONS_BLANKET WAREHOUSE
I am only going to be working with the below titles:
SKU BIN ONHAND ALLOCATED
AVAILABLE
For this specific example I am going to just work with my SKU's in my A locations.
My section of the warehouse is Isle 15-27
each isle is 13 row/bins long
and 4 columns high (A,B,C,D) A is the lowest location (pulling location)
I am wondering if there is a formula where I am able to take just the "A" locations.
But also once I have those "A" locations, if there is a way to insert a Space between each seperate Bin
for example:
If i have the following data
SKU BIN ONHAND ALLOCATED AVAILABLE
144-1-2154 16-01-A 73 0 73
281-0-6023 16-01-A 248 0 248
393-17P-7139 16-01-A 232 0 232
174-2-1269 16-02-A 126 45 81
396-3-2001 16-02-A 10 2 8
423-3-8351 16-02-A 303 2 301
803-3-2001 16-02-A 18 0 18
116-4-6442 16-03-A 79 1 78
254-4-5044 16-03-A 58 0 58
392-3-1191 16-03-A 3 0 3
859-2-1006 16-03-A 689 0 689
How can I take all of this data and efficently make it look like the following
144-1-2154 16-01-A 73 0 73
281-0-6023 16-01-A 248 0 248
393-17P-7139 16-01-A 232 0 232
174-2-1269 16-02-A 126 45 81
396-3-2001 16-02-A 10 2 8
423-3-8351 16-02-A 303 2 301
803-3-2001 16-02-A 18 0 18
116-4-6442 16-03-A 79 1 78
254-4-5044 16-03-A 58 0 58
392-3-1191 16-03-A 3 0 3
859-2-1006 16-03-A 689 0 689
See each bin is seperated, but all SKU's from that bin specifically are grouped together? Please let me know if you need me to explain this further, I am happy to attach a few more files that may give a better idea of what I am trying to accomplish!
