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

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?

Preparation

Accepted answers

NicoleJohnson

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?

CopyRowX.yxmd

All comments

NicoleJohnson

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?

CopyRowX.yxmd

adm510

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

New Workflow1.yxmd

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280