Views Grouping by Field I'm looking to display a list of staff grouped by department.  I've figured out how to do this just fine with one exception.

I have a few staff who's time is split between 2 departments.  However, when I edit their department field and enter more than one department, they show up in a new section.  For example.


  Outreach
  
  
    Joe Smith
    
    jane Smith
  
  
  Technical Services
  
  
    Joe Johnson
  
  
  Outreach, Technical Services
  
  
    Jane Johnson
  


Instead of having this separate display, I want Jane Johnson to be listed twice, under both Outreach and Technical Services.

Any ideas?
I'm not sure if you've had this answered yet, but in Drupal 7 and the latest version of Views, this is possible by doing the following:

Under Fields, click the one you want to configure, in your case it probably looks something like:
Content: Departments

Select Multiple Field Settings and it will drop-down to where you see a check mark in the box labelled:
Display all values in the same row

Uncheck this box and it should list your members twice, once in each department they are specified under.