Populating a table with rows based on another table

1

I’m still very much a beginner when it comes to coding formulas, so I’m unsure if this would even be possible.

I’m trying to make barcodes for many individual items that are grouped. My hope is that based on the data input into one table, pressing a button would then create all the barcodes instead of having to type out each one.

My table is currently set up as:

Base Barcode | Versions | Variants

The issue becomes, I would want the “Versions” to become a letter based on what number is input (ex. 3 = A / B / C, 1 = A)

So if I were to enter Base Barcode = 90103 | Versions = 2 | Variants = 4, the button would make the rows as followed:

90103A1
90103A2
90103A3
90103A4
90103B1
90103B2
90103B3
90103B4

Again, I’m unsure if this would even be possible as I don’t know where I would even start with a formula for this. Thank you for any help and feedback in advance!

2

Hi,

you can do like this :

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.