LinkBack URL
About LinkBacks
Hi,
Originals:
I have these two collumns, one gives me a code, and another gives me the number of times that codes has to be repeated.
Step 1:
First I have to take all the rows where the number is bigger than 1 and duplicate it the number of times written in the code cell.
Step 2:
Then I have to add another cell with a new code that makes a difference between the repeats, for example, .a / .b / .c / if the number in the cell is 3. If it is larger than 3, actually for example larger than 40, at the end of the alfabet I have to restart with aa, bb, cc.
Also adding to this complexity I cannot use certain letters, like i and o. So I'm thinking I should define what letters I can use based on how big is the number in a separate place, although I'm not sure.
End result:
At the end I should be left whith two rows, one where the number is alsways equal to 1 and another with the new code.
Question:
I've been doing these manually thus far, however I think there should be an automatic way of doing it but it escapes me.
Attached you can find a file containing the steps outlined above: Example_AV_160125.xlsx
Register To Reply
Originally Posted by ALecsx
Bookmarks