Pivot Tables

Hi Ceris

Thank you for your question. This should work where there is a one to one mapping between the fields. An employee number column and name column for example. You should be able to add these to the data row area without Excel grouping the data.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew