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 | qq | Original Row |
| SDS | qwww | 121 | R | QQQQ | 456 | 23345 | CCCC | 455678 | Chennai | tana | 56.77 | 777777 | qq | 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 |
