Dinesh_Excel
Member
Hello Friends,
I'm trying to insert 3 rows into my existing for a data of 1500 rows.The condition is upon satisfying a text between these row.
For eg
Column D contains the below rows for 1500 records.
Design 1
Build1
Testing1
Rework1
Contingencies1
Design2
Build2
Testing2
Rework2
Contingencies2
The above series continues for 1500 records.
The ask is we have to insert 3 rows down to wherever we find text "Testing" across 1500 records with Q1,Q2,Q3 in those 3 new rows. it should look like the below .
Design 1
Build1
Testing1
Q1
Q2
Q3
Rework1
Contingencies1
Design2
Build2
Testing2
Q1
Q2
Q3
Rework2
Contingencies2
Appreciate your help on the above.
Thank you
I'm trying to insert 3 rows into my existing for a data of 1500 rows.The condition is upon satisfying a text between these row.
For eg
Column D contains the below rows for 1500 records.
Design 1
Build1
Testing1
Rework1
Contingencies1
Design2
Build2
Testing2
Rework2
Contingencies2
The above series continues for 1500 records.
The ask is we have to insert 3 rows down to wherever we find text "Testing" across 1500 records with Q1,Q2,Q3 in those 3 new rows. it should look like the below .
Design 1
Build1
Testing1
Q1
Q2
Q3
Rework1
Contingencies1
Design2
Build2
Testing2
Q1
Q2
Q3
Rework2
Contingencies2
Appreciate your help on the above.
Thank you