roblems with creating my pivottable because of the way my data is structured

A

arnaudlalu

I am looking for a way to create a pivottable from a table that is structured like this :

name 1/01/13 2/01/13 3/01/13 4/01/13
Mike Project A Project A Project C Project C
George Project C Project A Project C Project A
Steven Project A Project A Project A Project C
Al Project A Project B Project B Project B

What I need is a pivottable with the name of the projects in the left row and the dates in the column. The pivottable needs to show the who has worked on a particular project and the specific date.

project 1/01/13
Project A Mike, George , Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
How to create a Pivottable with text only data 1
help with Sum in between dates 12
Help with SUMPRODUCT 16
calculation based on the range you indicate in another cell 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Sorting problem : "The sort reference is not valid..........." 3
Simultaneously create records in multiple tables 2

Top