This might be a bit confusing, I will try and explain it as best I can.
I have two lists in SharePoint:
List A has a lot of columns per "item/record", one of the columns is populated by list B which is a multi-select field.
A co-worker wants to create a view that shows each item in list B in column 1; in column 2 they want to show every item name from list A.
List A default view:
- Col 1 - Col 2
- item 1 - item a, item b, item c, item f, item q
- item 2 - item c, item f, item q
- item 3 - item a, item c
They would like to create a view like this.
- Col1 - Col 2
- item a - item 1, item 3
- item b - item 1
- item c - item 1, item 2, item 3
- item f - item 1
etc... I think I've made the point clear? Or I just muddied the waters.