Duplicate row

Hello,

Let's say I have 3 columns with different data. What I would like to achieve is to duplicate row number 1 but taking only data which is highlighted green so TEST 1. Is it possible to do that? If yes can anyone of you propose me a solution?.

PS. What if there will be more columns?, solution will be the same or different?

duplicate row.JPG

Best Regards,

Sebastian

Book1.xlsx

Help

Accepted answers

davidskaife

Hi @sebastiank88

Here is one way of doing it. Use a Sample tool to ensure only the first row is used, then a Dynamic Select tool to pick just the first column, then Union it back to the original data:

Number of columns, nor name of columns, won't matter!

Duplicate Column.yxmd

All comments

davidskaife

Hi @sebastiank88

Here is one way of doing it. Use a Sample tool to ensure only the first row is used, then a Dynamic Select tool to pick just the first column, then Union it back to the original data:

Number of columns, nor name of columns, won't matter!

Duplicate Column.yxmd

OTrieger

@sebastiank88
You can use Generate Rows and then with Multi-Row Formula tool delete the content of the from the fields. This is a bit more robust solution as you could do it for multiple rows, as many as needed. However if you need to add only one row go with the above solution as it is super simple.

sebastiank88

Hi David

Ok, sounds really good.

Have another question what if I would like to duplicate only Test 1 from column A and Test 3 from Column C (from your example above). What will be solution for that?

davidskaife

Simply update the Formula in the Dynamic Select to [FieldNumber] IN (1,3)

sebastiank88

Perfect, thank you!

davidskaife

You're welcome!

If you need to add in more columns, simply update the IN formula to include those you need

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703