Hi,

I have a pivot table which I am trying to create. I have grouped some parts
together and I am trying to get the grouped field to show on each line
instead of just once. The exaample below is what I am working with. I would
like the salesman field to appear on each line.

The pivot looks like:

Salesman Customer
ABC1 smith
jones
bates
ABC2 name1
name2
etc

Please can you help?

Many thanks

Jason