Dynamically creating new rows from a cell with a range of values

Question

I am trying to dynamically create new rows from a column that has a range of values (e.g. 0100 - 0199).

I am looking to create a row for each value (0100, 0101, 0102, etc.)

Category CodeCategory NameSIC Code

1Agric  Agriculture0100-01991Agric  Agriculture0200-02991Agric  Agriculture0700-07991Agric  Agriculture0910-09191Agric  Agriculture2048-20482Food   Food Products2000-20092Food   Food Products2010-20192Food   Food Products2020-20292Food   Food Products2030-20392Food   Food Products2040-2046

I have attached the entire file for reference as well.

Thanks,

SIC Codes Decoder Ring.xlsx

OllieClarke · Accepted Answer

Hi @wvanbus93 You can use the generate rows tool to do this:

Jonathan-Sherman · Accepted Answer

Hi @wvanbus93,

I think this is what you're trying to achieve, i've used the generate rows tool.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan