List data into table

Help! I'm struggling with something that should be really simple

I have data in a list of sales people and dates of their sales calls. What I want to do is transform the list into a table as shown in the attachment.

Then I want to calculate the number of days between the first and last sales call. This part is easy using date formatting and min/max I guess. What I can't do is get the table arranged. I have used a pivot table to count the number of calls per sales person but pivot table wont just display the dates in a table format, it will only sum or count etc.

Hope this makes sense. Any help gratefully received!!

Thanks
Tom

Hi,

Here's a way with formula's, see the attached yellow cells with the formula's. Once you have combined the data on one line for each individual, then copy > paste special > values, then sort the data to eliminate the blank rows.

Does that help?

Tom41,

Please add the link to the other excel forum as per forum rules below

VBA Noob