Pivot Table - how to display data in columns not rows

[tribefan]

Hi,
This seems simple but I am having trouble. I have a simple pivot table with ID as the row field, and then I want my data items displayed across not down. The default view is that each row field (ie ID) then has a rows for the data items (Sum of Amount, Sum of Paid, etc.) I want each data field listed in its own column. Basically I just want to flip the report.

Any ideas of how to do this? I greatly appreciate any help!

ps. I tried in table options changing the format to "over, then down" but nothing happens.

 

[Andrew Poulsom]

Click on the Data button and drag it to the right.

 

[tribefan]

Wow that was so easy - I'm ashamed I couldn't figure that out! THANK YOU SO MUCH!!!