if [Records count] = "1" then create a new record row using [Bulk Code + "A", if [Records Count] = "2" then create 2 new records rows using [Bulk Code] + "A" and +"B". For example, bulk code is 21-0004 records count is 1, new row of data will be created to 21-0004A, if the records count is 2, 2 new rows of data will be created to 21-0004A and 21-0004B.
The final Output will be something like:
Bulk Code | Records Count | New Bulk Code |
21-0004 | 1 | 21-0004A |
21-0005 | 2 | 21-0005A |
21-0005B |
Solved! Go to Solution.