Copy Row 'x' (defined in another column) times

[Dezzie]

I have a data set that specifies a list of values and the number of times to "copy" them. For example,

Fruit	Copy Num
Apple	2
Orange	4
Banana	3

The output set I'm trying to achieve is this:

Fruit

Apple-1

Apple-2

Orange-1

Orange-2

Orange-3

Orange-4

Banana-1

Banana-2

Banana-3

I looked into the Multi-Row Formula tool but wasn't able to figure out how to go about doing this. Does anyone have any suggestions?

[NicoleJohnson · Accepted solution]

Try the attached!

1. Use the Generate Rows tool to create a new line for every number X-1 until you get to 1

2. Formula tool to concatenate the original column name with the new RowCount # to get your combination

Does that work? :)

NJ

[adm510]

Use the generate rows tool. Take a look at the example I attached

[wvonderrosen]

Clutch!, thank you!

[rebekajackson]

Brilliant, I needed a very similar solution - but mine was because the "count" needed to combine with the "unique string" to get a field with "unique string.1,...,unique string.count".

I wasn't sure if my data had unique rows so I added a record ID before I duplicated the rows, before including that in the "group by" and "concatenate" steps to get what I needed.

Never used the generate rows tool before, very helpful!