This is quite a difficult one to explain, so I've attached an example.
In this attachment there are 2 sheets. The first sheet "To go from this" shows a simple example of what I currently have. It is basically a set of tests which have a high level description (signified by a Y in the HL column.)
Each high level description has a number of steps to perform that test.
What I need to to is convert these into what is shown in the "To this" sheet. All the fields are colour coded, but the colours aren't necessary.
I am hoping that there is a way of doing this automatically, but i have no idea where to begin.
I hope this makes sense. Many thanks for your help.
In this attachment there are 2 sheets. The first sheet "To go from this" shows a simple example of what I currently have. It is basically a set of tests which have a high level description (signified by a Y in the HL column.)
Each high level description has a number of steps to perform that test.
What I need to to is convert these into what is shown in the "To this" sheet. All the fields are colour coded, but the colours aren't necessary.
I am hoping that there is a way of doing this automatically, but i have no idea where to begin.
I hope this makes sense. Many thanks for your help.