You probably have a Unique Invoice # for each invoice.
Put that in the row headers, and the columns you want in the column headers, and you should have what you want.
The alternative is to "Format as table", filter the columns you want, and then "Hide Columns".
Please click the * icon below if I have helped.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks