Hi Melvin - thanks for your suggestion - the table still isnt populated with data inside it. I now have the unique job numbers as rows in the table and the data i want as column headers. I want that data in columns against the job number so, for example, I have:
job no. 123 - location: UK - date: 4 march - etc.
job no. 456 - location: US - date: 8 april - etc.
The pivot table wants to add the locations together not ust report them on the same line as the job number.....
HELP!