Table of intersecting data

Hello - i have a 3 columns of data: Team 1, Team 2, Date.

Using this data, I am trying to use a pivot table in order to display on a seperate sheet: Team 1 vertically in column A, the date horizontally across the top and Team 2 in the 'intersection'.

Unfortunately this is giving me a 'Count of Team 2'.

Question: How do i display Team 2 name in the data area?

thanks,
HBM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

With Pivot tables, you have to have some sort of summary in the Data range... not text fields...

so best thing is probably to list the Team 1 list down a column and the Dates along the top row.. then use formula like this:

=Index(Sheet1!$B:$B,Match($A2,Sheet1!$A:$A,0),Match(B$1,Sheet1!$C:$C,0)) and copy down and across the table...

where Sheet1!A:C hold the raw data and A2 on active sheet holds first Team 1 category and B1 holds first date...

... formula would be inserted in B2 and copied down and across.