jimgima
New Member
- Joined
- Sep 19, 2006
- Messages
- 26
I'm making a simple pivot table. It should be very easy, but it's kicking my butt. Please help.
Here is Sheet 2 (Data simplified for ease of understanding)
Column A:Names Column B:Course column C: Due Date
So the spread sheet would look like this:
Bob / Math / 20 Aug 07
Bob / Art / 30 Jul 07
And so on...
I want the pivot table to look like this...
column A Name Column B course column C course...
the data in the middle would be the due dates. (like this)
Name:::Math:::::::::::Art
Bob:::::20 Aug 07::::30 Jul 07
The problem is that all of the date only show up at the number 1
Please help.
Here is Sheet 2 (Data simplified for ease of understanding)
Column A:Names Column B:Course column C: Due Date
So the spread sheet would look like this:
Bob / Math / 20 Aug 07
Bob / Art / 30 Jul 07
And so on...
I want the pivot table to look like this...
column A Name Column B course column C course...
the data in the middle would be the due dates. (like this)
Name:::Math:::::::::::Art
Bob:::::20 Aug 07::::30 Jul 07
The problem is that all of the date only show up at the number 1
Please help.