Specific data to be copied to below row

Question

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.

ABCDEFGHIJKLMN ASSqwww121OQQQQ5678888AAA1234455Delhiana2.3466666zz ASSqqqqq121RQQQQ5689999BBBB233456Banglurumana3.45666666aaOriginal RowASSqqqqq121RQQQQ5689999BBBB233456Banglurumana3.45666666aaDuplicate RowSDSqwww121RQQQQ45623345CCCC455678Chennaitana56.77777777qqOriginal RowSDSqwww121RQQQQ45623345CCCC455678Chennaitana56.77777777qqDuplicate RowCVFqqqqq23RWWW567567DDDD4556Hapursana98.4488888bbOriginal RowCVFqqqqq23RWWW567567DDDD4556Hapursana98.4488888bbDuplicate RowGRTqwww45OWWW568678WWW8889Noidazana44.266666cc HTYqqqqq56SWWW4563455WWW9888Delhibana1.23444rr LMNqwww76TDDD567111SSSS5677ghakana2.343333ff GFDqqqqq89RDDD5680TTTT1234455zhadana4.562222ggOriginal RowGFDqqqqq89RDDD5680TTTT1234455zhadana4.562222ggDuplicate Row

Data tp be pasted to below row.xlsx

Thableaus · Accepted Answer

Hi @mmustkee

See attached.

Cheers,

AngelosPachis · Accepted Answer

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