I'm handling multiple items on multiple projects, I want to enter data as "date", "Project", Item", "Description", "Action Req'd"
I want a pivot table on sheet 1 for project 1 (easy - filter by project)
Then item by date (easy. rows "item", "Date" )
This is where I loose it -- on the same row as the date, I want the "description" then in the next column of the same row I want the "Action Req'd"
Data table:
11/16 proj 1 item 1 rec'v approval drawings
11/29 proj 1 item 1 ordered hardware
11/29 proj 2 item 10 delivered final drawings
PIVOT TABLE
PROJECT Proj 1
Item 1 11/16 rec'v approval drawings
11/29 Ordered hardware
Any ideas?
What exactly is the issue? If it's just getting them on the same row, set the pivot table layout to tabular.