I found the Classic View option gets me closer, yet the labels don't copy
down to all rows.

Still seeking assistance,

Thanks

"ToddEZ" wrote:

In Excel 2003 I could add 2 data elements to the Row label area of the pivot
table and both items would show up on each row in a different column, in 2007
all items in the row label box show up in the same column.

I'd like to go back the 03 way, any suggestions?

Example Excel 03:
SSN Name Source
123-45-6789 Bob Smith 1
123-45-6789 Bob Smith 2
123-45-6789 Bob Smith 3

Eample Excel 07:

123-45-6789
Bob Smith
1
2
3