lostyankee
New Member
- Joined
- Jul 14, 2019
- Messages
- 7
I need to create a file for data uploads that contains values in 5 separate columns (DC, Stores, SKUs, Case Pack, Quantity). Essentially, i need to create a line for each SKU and Store, and lookup the corresponding DC, case pack and quantity.
To repeat the store list, I'm using the following: =CHOOSEROWS(B2:B200000, MOD(SEQUENCE($P$3*$P$1)-1,$P$3)+1) where B is the list of stores, and P3=number of skus, and P3 is the number of stores (so repeat the store list for however many SKU's there are in the list. This works fine.
To repeat the list of SKU's, I'm using this formula: =INDEX($C$2:$C$1000, INT(SEQUENCE(COUNTA($C$2:$C$1000)*$P$3,,1,1/$P$3))) wher C is the list of SKU's, and P3 again is the number of stores, so repeat each value to match the number of stores.
For some reason, this works fine except for 4 cells. I cannot see the error, it has to be staring me in the face.
To repeat the store list, I'm using the following: =CHOOSEROWS(B2:B200000, MOD(SEQUENCE($P$3*$P$1)-1,$P$3)+1) where B is the list of stores, and P3=number of skus, and P3 is the number of stores (so repeat the store list for however many SKU's there are in the list. This works fine.
To repeat the list of SKU's, I'm using this formula: =INDEX($C$2:$C$1000, INT(SEQUENCE(COUNTA($C$2:$C$1000)*$P$3,,1,1/$P$3))) wher C is the list of SKU's, and P3 again is the number of stores, so repeat each value to match the number of stores.
For some reason, this works fine except for 4 cells. I cannot see the error, it has to be staring me in the face.
