Stump the Panel: SharePoint Q&A

I was wondering if there was a way to display a view with a grouping on a multi value field. The example I am thinking of is have a view similar to the yellow pages where an individual could show up under multiple categories.
Category 1
Item A
Item B
Category 2
Item B
Category 3
Item A
Any suggestions or ideas would be greatly appreciated.

I have had this type of thing work, but I think it was a fluke. I changed a multiple choice category to a single choice category and then had things show in multiple places. Of course that limits any new entries.

I have a similar situation where I created a web part page and then used multiple filtered views of the same list to get the look I was after. Hiding the titles of each web part gives the illusion of all one list.

If this is a choice type field, could you not use a groupby on that field?

When the field is a choice and you have clicked on the "Checkboxes (allow multiple selections)" then it is not a field that you can group by. In my case I would like the field to be a lookup to another list so that the choices can be maintained by the users.

A groupby can be obtained. it is not a clean method but I will do my best to describe. Some time back before this great site had to move there was a post related to creating a calculated field that could read multiple line or multiple select.
First you have to trick the calculated field.
create a single line text field, Name it MyChoice (this will be deleted and recreated later).
use the name of your multiple select field. correct you cannot create your multiple line or multiple select first.
once the single line field is created, create the calculated field and name it MyGroupChoice
Set calculated value of MyGroupChoice equal to MyChoice
delete MyChoice field
Create new multiple select, or multipleline field named MyChoice
now create a view that groups by calc field MyGroupChoice where value "contains" your view data.

there is also a jquery script at http://sharepointjavascript/ that converts singleline fields into multiple select fields, where you can still use some of the above steps and groupby. this author Alexander has worked much magic.