ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting the data (https://www.excelbanter.com/excel-discussion-misc-queries/144145-formatting-data.html)

Arain

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.


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com