B
BFalana
Hello,
I am trying to construct a pivot table that uses merged cells.
created a sample excel table that shows what I am trying to do, it'
extremely simplified but shows all of the things that I am trying to do
I have a list of projects that have start dates, project types, an
which workers are assigned along with what role they are for th
project. I want to use a pivot table so I can sort in different ways
such as: sorting by the workers and which projects are assigned t
each, sorting by projects and viewing which project type(s) they are
etc.
The easiest way I figured I could satisfy these requirements was by th
use of merged cells, like I've shown in the example file attached, bu
the pivot table doesn't seem to work in the way I'd like it to (fo
example, when I sort by jobs and try to view the workers, it will onl
show the first worker's name instead of all names on a job).
If anyone could help me with this, it would be greatly appreciated.
Thank you
+-------------------------------------------------------------------
|Filename: Pivot Table Merged Cell Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=291
+-------------------------------------------------------------------
I am trying to construct a pivot table that uses merged cells.
created a sample excel table that shows what I am trying to do, it'
extremely simplified but shows all of the things that I am trying to do
I have a list of projects that have start dates, project types, an
which workers are assigned along with what role they are for th
project. I want to use a pivot table so I can sort in different ways
such as: sorting by the workers and which projects are assigned t
each, sorting by projects and viewing which project type(s) they are
etc.
The easiest way I figured I could satisfy these requirements was by th
use of merged cells, like I've shown in the example file attached, bu
the pivot table doesn't seem to work in the way I'd like it to (fo
example, when I sort by jobs and try to view the workers, it will onl
show the first worker's name instead of all names on a job).
If anyone could help me with this, it would be greatly appreciated.
Thank you
+-------------------------------------------------------------------
|Filename: Pivot Table Merged Cell Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=291
+-------------------------------------------------------------------