Dear All,
Faced with a problem. I have steps for doing testing in one cell but I need to put them in multiple rows.
Example
A B C D
1Test Case Name Description Step Expected Result
2 To check user add user check Step 1: Open Sys User added
Step 2: Login admin
Step 3: Add user
Step 4: Logoff
3 To check user del user deletion Step 1: .... User Deleted
Basically in Cell C2 all the steps have been written with carriage returns (Alt + Enter).
The logical sequence that I want is : -
a) Cursor moves to the column
b) Counts the number of sub steps and reduces one from it
c) inserts Blank rows under that row one for each sub step
d) Keeps the first row as it is
e) pastes Step 2 onwards into C3, C4 onwards. No other data to be replicated
Output required is
A B C D
1Test Case Name Description Step Expected Result
2 To check user add user check Step 1: Open Sys User added
3 Step 2: Login admin
4 Step 3: Add user
5 Step 4: Logoff
6 To check user del user deletion Step 1: .... User Deleted
Please note that C3, C4 & C5 now have the relevant steps
I am ok for running the program for each such cell or one shot for all.
Appreciate your help or any questions
Mukul
Bookmarks