Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Formatting in Excel/Macro
I have the data format as follows in the pivot Table:
Job date time CPU-Usage --- ---- ---- --------- Job1 1st Jan 10:00 10 Job1 2nd Jan 10:00 10 Job2 1st Jan 10:30 10 Job2 2nd Jan 10:40 10 Job2 2nd Jan 10:44 10 Job3 1st Jan 10:40 10 Job3 1st Jan 10:54 10 Job3 2nd Jan 10:07 10 Job3 2nd Jan 10:10 10 This table is created in Pivot table. Since a Cut, Delete, Paste cannot be done on this a macro for the below layout seems diificult. There are multiple runs of the same job on the same day.However, The first run of each job and its details on the same day MUST exist on the SAME LINE, as shown below Job 1 Job 2 Job 3 ETC 1 Jan 1 Jan 1 Jan 1 Jan 2 Jan 2 Jan 2 Jan 2 Jan 2 Jan 3 Jan 3 Jan 3 Jan Just that we want the these jobs and details side by side date wise. Please suggest how this can be achieved by Macro? Or any other excel Function. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Formatting in Excel/Macro
Have you tried "Paste Special", "Transpose"? seems like the easiest way to
turn the table on its side. "Sadanand Padmawar" wrote: I have the data format as follows in the pivot Table: Job date time CPU-Usage --- ---- ---- --------- Job1 1st Jan 10:00 10 Job1 2nd Jan 10:00 10 Job2 1st Jan 10:30 10 Job2 2nd Jan 10:40 10 Job2 2nd Jan 10:44 10 Job3 1st Jan 10:40 10 Job3 1st Jan 10:54 10 Job3 2nd Jan 10:07 10 Job3 2nd Jan 10:10 10 This table is created in Pivot table. Since a Cut, Delete, Paste cannot be done on this a macro for the below layout seems diificult. There are multiple runs of the same job on the same day.However, The first run of each job and its details on the same day MUST exist on the SAME LINE, as shown below Job 1 Job 2 Job 3 ETC 1 Jan 1 Jan 1 Jan 1 Jan 2 Jan 2 Jan 2 Jan 2 Jan 2 Jan 3 Jan 3 Jan 3 Jan Just that we want the these jobs and details side by side date wise. Please suggest how this can be achieved by Macro? Or any other excel Function. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with custom number formatting | Excel Discussion (Misc queries) | |||
Formatting web imported data correctly | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Formatting data | Excel Discussion (Misc queries) |