View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arain Arain is offline
external usenet poster
 
Posts: 49
Default 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.