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

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