This content has been marked as final. Show 2 replies
I have four three items of data:
I would like to create a chart that has the date accross the top, the location down the left, and the persons name(s) in the middle combined.
The dates should be distinct, so for example the 1/3/2012 should only appear once and the names will be combined into one field.
Having difficulties doing this. Have tried to use a straight table and pivot table but have no luck. Names seem to be missing even though selected.
I would like to have what is shown in the attached excel file. Sample data also attached on second tab.
Thanks for any help that you could provide...