How to have multiple columns in pivot table data area?

I have a pivot table that has the following columns

Username, Data, Total

For each occurrence of username I have inserted to the data area 2
fields, total number of jobs submitted and the total duration of those
jobs.

The resulting table shows 2 rows per username with the correct results
and with the field name repeated over and over, what I want is to
display the results as a column each with the field name as the column
header.

How do I do this?

regards
Mitch


--
mitch1962

To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'.

There are instructions with pictures here:

http://www.contextures.com/xlPivot02.html


mitch1962 wrote:
> I have a pivot table that has the following columns
>
> Username, Data, Total
>
> For each occurrence of username I have inserted to the data area 2
> fields, total number of jobs submitted and the total duration of those
> jobs.
>
> The resulting table shows 2 rows per username with the correct results
> and with the field name repeated over and over, what I want is to
> display the results as a column each with the field name as the column
> header.
>
> How do I do this?
>
> regards
> Mitch
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html