Multi-Row Formula Tool to create additional data

[lwilson2023]

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

[SPetrie · Accepted solution]

You need to use the Generate Rows tool, not the Multi-Row