How to create a row(s) based on a cell's value

[nickrosen28]

Hi everyone,

I have a data set that tells me which aircraft a set of parts are for, but some cells will say for example set "1-15".

In this instance i would need 15 rows that repeat all the data except have a cell for each row say what aircraft.

I.e. one row saying "1", the next row saying "2", the next saying "3". If a cell says "3-10" I would need one saying "3" one saying "4" and so on.

Any help will be greatly appreciated!

[apathetichell · Accepted solution]

excel files help .png files do not. is this always separated by hyphens? if so - you create two tools:

1) formula tool.

create field start tonumber(regex_replace([fieldname],"^(\d+)-.*","$1"))

- this should be an integer

create field end:

tonumber(regex_replace([fieldname],"^\d+-(\d+)","$1")_

next - generate rows. initial value is your start field

Expression is rowcount <= [end]

[AndrewDMerrill · Accepted solution]

Simple solution to a hopefully simple problem (change column names as desired/necessary; Included is a slight variation on @apathetichell 's solution). MVT (Most Valuable Tool) for this problem is the Generate Rows Tool followed closely by the Text To Columns Tool:

Happy Solving!