How to create this chart?

[#1]

Hello All,

I have four three items of data:

ID,

PersonName,

Date,

Location

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...

Regards,

Jim

[MayilVahanan · Accepted solution]

Hi

     Use pivot table, Use Location and Date as dimension ..

     And Use Concat(Distinct PersonName, ',') as Expression

     Hope it helps

[#3]

Thank you Mayil,

This worked just fine.

Regards,

Jim