Hi Sisyphus,
This is a continue thread from my post from the old forum: http://www.teachexcel.com/forum/viewtopic.php?f=3&t=1058
Below are the answers to the questions:
You asked: The best way to start is to create the final result with hard data. From there you work backward to replace the hard data with soft. So, create a worksheet that holds, say, 3 sets of resolved data.
Answer: Yes, attached is the excel (expected.xlsx) with the expected data. As you can see column D now has each step as an individual row and all the data in the spreadsheet is shifted down. This is final excel format that I am looking to achieve.
You asked: Secondly, provide the source data. Best, provide the same 3 sets of data that you put manually in the Result sheet created in step 1. You say you want to export them to Excel. You also said they are in an Excel cell. What is their original format?
Answer: The source data is the attached spreadsheet: "AcceptanceTestCases.xlsx" where you can see column D just has one row of data for all the steps in each test case. This is the original format of column D and I want the same column to look like what I provided in the spreadsheet: expected.xlsx
Below is an example of one row original vs expected:
Column D Original:
1. Navigate to studio with a PBC in advanced mode http://www.vptest.com/vp/ns/studio3.aspx?pf_id=088&cfs=-1&combo_id=3956&advmode=true 2. Click the add text button in the toolbar 3. Enter text to the text field 4. VERIFY that the new text box has been added to the canvas 5. VERIFY that there is a new text field on the left side of studio named "Text Field 1" 6. Click back side and click the front side (in order to get the doc id) 7. VERIFY that the text to the text field is applied to canvas
Column D expected:
"1. Navigate to studio with a PBC in advanced mode
http://www.vptest.com/vp/ns/studio3.aspx?pf_id=088&cfs=-1&combo_id=3956&advmode=true "
2. Click the add text button in the toolbar
3. Enter text to the text field
4. VERIFY that the new text box has been added to the canvas
5. VERIFY that there is a new text field on the left side of studio named "Text Field 1"
6. Click back side and click the front side (in order to get the doc id)
7. VERIFY that the text to the text field is applied to canvas
You asked:By the way, I find it odd that you want the data in several rows. Mostly, people want data in several columns. Any particular reason for this that you can share with me?
Answer: I want the data in several rows because that is the format I will use to eventually export all the data in the spreadsheet to another tool. This spreadsheet is a placeholder of all data in the required format to get it exported into another inhouse office tool.
Please let me know how to get started with this conversion process. Also at the end of the each step I think there is an enter key to recognize the delimeter. Or can we use "space-number-dot" as a delimeter because each new step starts in that format.
Thanks much,
Sandeep