How to have multiple columns in pivot table data area?

[mitch1962]

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]

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