Forum Discussion
Chrismultiair9810
Nov 16, 2023Copper Contributor
sequence of warehouse locations
Hi all, i want to creat a sequence of letter-number combination Starting with AA01A01 until AA01A10 Then AA01B01 until AA01B10 further on until level E (AA01E10), witch is the last for rack AA , 1...
- Nov 16, 2023
Chrismultiair9810 You're welcome
To help others with a similar challenge could you take a few seconds to click on Mark as response at the bottom of the solution you adopted?
Thanks & Nice EOD...
Lorenzo
Nov 16, 2023Silver Contributor
Don't understand how you get 100 combinations/rack, I get 50. So attachment is probably not what your looking for...
Done with Power Query:
- Put the "root" of the rack in the blue table
- Right-click in the green table > Refresh
If not good please explain you get 100 combinations/rack