Formatting the data
This is how the original data is in the table
Name Start Continue Stop
NS SNS1 CNS1 STNS1
NS SNS2 CNS2 STNS2
RS SRS1 CRS1 STRS1
RS SRS2 CRS2 STRS2
This is how it should look on the report
Name NS
Start
SNS1
SNS2
Continue
CNS1
CNS2
Stop
STNS1
STNS2
Also you must have noticed I want to add the remove the duplicate name
field. Just copy the values for the name into Start Stop and Continue rather
than have another field defining it.
|