Pivot Tables - I want all source data as separate lines

[turbotime]

So I have multiple large data sets exported from credit card statements and I've formatted them for use in monthly pivot tables to track our expenses. On the left side I use date then vendor for row headers and as column headers Account names and number code. Expenses are broken out to track where the money is being used, hotels, rental cars, crew meals..etc. The problem comes when there is more than one charge from the same vendor on the same day. Four separate hotel rooms at the same hotel for example, or three trips to home depot...etc. Pivot Table likes to lump them into one line if the vendor is exactly the same. I'd like to be able to view each charge as a separate line on the pivot table for archiving purposes as to not have to reference the master credit card statement. Can this be done?

[oeldere]

use a seperated column to count the vendor.

after that you can combine the count of vendor with the vendor to create a unique vendor.

after that you can use that column in your pivot table.

[Excel Mechanic]

Click anywhere on your pivotTable.
Click on the Design tab.
Select Report Layout -> Show in Tabular Form
Select Report Layout again -> Repeat all Item Labels

Attachment for illustration
pivottable with individual row labels.JPG

[turbotime]

Perhaps I should mention I'm using Mac 2011. I see no option to Show in Tabular Form under the Layout window in Pivot Table options.

[Excel Mechanic]

Try under the Pivot Table ribbon -> design section -> Layout.

Hope it works. Just a guess from me as I don't use that version.