pivot table orientation

[craig_100]

I need to create a pivot table which shows employee names in col A, wit
category headings in row 1. Then I need for the table to show eac
category's data, by employee (i.e. 1 row / employee), instead of eac
category's data being grouped by employee (i.e. xx rows / employee). I
there a way to do this that I'm missing? Thanks

 

[craig_100]

Agreed. That solution works perfectly