I have a list of 10,000 + alphanumeric numbers in a column.
10AA, 10AB,10AC...After 10AZ it will switch to 11BA.
I need to create 9 sub numbers for each group and store them separately - they will become their own list in a column.
So I need from the master number a new list that looks like this.
10AA1, 10AA2,10AA3...10AA9, 10AB1, 10AB2, 10AB3...10AB9...Through 10AZ9 and than switch to 11AA1...
So how do I create 10,000+ groups of 9 each sequentially numbered?
Thanks in advance,
Mark
Bookmarks