Hi Team,
Please refer attached. I need to select 'R' from column 'D' and wants to create a duplicate row along with all the data. Please create a blank row below wherever we have 'R' in column 'D' and paste all data from 'R' row to below blank row. do this for all wherever we have 'R' in column 'D'. For example please refer below.
Thanks for your help in advance.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
ASS | qwww | 121 | O | QQQQ | 567 | 8888 | AAA | 1234455 | Delhi | ana | 2.34 | 66666 | zz | |
ASS | qqqqq | 121 | R | QQQQ | 568 | 9999 | BBBB | 233456 | Bangluru | mana | 3.45 | 666666 | aa | Original Row |
ASS | qqqqq | 121 | R | QQQQ | 568 | 9999 | BBBB | 233456 | Bangluru | mana | 3.45 | 666666 | aa | Duplicate Row |
SDS | qwww | 121 | R | QQQQ | 456 | 23345 | CCCC | 455678 | Chennai | tana | 56.77 | 777777 | Original Row | |
SDS | qwww | 121 | R | QQQQ | 456 | 23345 | CCCC | 455678 | Chennai | tana | 56.77 | 777777 | Duplicate Row | |
CVF | qqqqq | 23 | R | WWW | 567 | 567 | DDDD | 4556 | Hapur | sana | 98.44 | 88888 | bb | Original Row |
CVF | qqqqq | 23 | R | WWW | 567 | 567 | DDDD | 4556 | Hapur | sana | 98.44 | 88888 | bb | Duplicate Row |
GRT | qwww | 45 | O | WWW | 568 | 678 | WWW | 8889 | Noida | zana | 44.2 | 66666 | cc | |
HTY | qqqqq | 56 | S | WWW | 456 | 3455 | WWW | 9888 | Delhi | bana | 1.23 | 444 | rr | |
LMN | qwww | 76 | T | DDD | 567 | 111 | SSSS | 5677 | gha | kana | 2.34 | 3333 | ff | |
GFD | qqqqq | 89 | R | DDD | 568 | 0 | TTTT | 1234455 | zha | dana | 4.56 | 2222 | gg | Original Row |
GFD | qqqqq | 89 | R | DDD | 568 | 0 | TTTT | 1234455 | zha | dana | 4.56 | 2222 | gg | Duplicate Row |
Solved! Go to Solution.
Hey @mmustkee ,
You can do that by using a filter tool to isolate the records you need and then use a generate rows tool to create the duplicate rows by setting the generation limit to 2
Hope that helps,
Angelos