#1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) ship Excel Discussion (Misc queries) 24 April 25th 06 06:02 PM
my formatting changes do nothing to the data Alex Excel Worksheet Functions 5 July 17th 05 04:09 AM
formatting data smithrdsr Excel Worksheet Functions 4 April 10th 05 07:15 PM
Formatting data rn Excel Discussion (Misc queries) 1 March 17th 05 10:01 AM
data formatting Choung Chao Excel Discussion (Misc queries) 2 December 24th 04 01:58 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"