Combining Data with Increments

[KamenRider]

Good day,

I would like to ask for your assistance how I can include increments as results of my data. The grouping of my result is composed of 5 category concatenating the following:

1. Box Number

2. Code

3. For each name, there is a corresponding code which increment, for example all data with BPO should increment regardless if it is not chronological. See screenshot below

4. Month and Year 123 means January 2023 as shown below.. therefore if it is February, the result should be 223.

By the way, under box number column, 133106720-APP should be 133106720 only. Same with 453106720-BPO which should be 453106720 only. 

The combined category shown below is the result I would like to do, my problem is what formula or tool should I used to have it incremented.

 

Hope to help me in this problem.

Thanks,

Kamen

[ShankerV]

Hi @KamenRider 

To have the result in the same format like the input only, I have used RecordID.

Sort the final input to get the expected result.

Expected output:

453106720_R-LIT-1-123
453106720_R-APP-1-123
153106720_R-BPO-1-123
253106720-BPO-2-123
353106720-BPO-3-123
453106720_R-BPO-4-123
553106720_R-BPO-5-123
653106720_R-BPO-6-123

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[binuacs · Accepted solution]

@KamenRider One way of doing this

[KamenRider]

Thank you so much @binuacs @ShankerV , solutions are both applicable. Most importantly It gives me more details about how to use the Tile tool.

Thanks for the assitance.

Kamen