In a table, I had 4 fields, Knowledge Base, Domain, Groups and Users.

[Raghu Ram Y]

I have a table with four fields: Knowledge Base, Domain, Groups, and Users. The Groups and Users fields are list collectors. I need to create a database view or report that displays each user and each group as a separate record.

Example :

At Present

Knowledge Base	Domain	Groups	Users
KBA	global	GroupA,GroupB,GroupC	UserA, UserB, User C

My Expectation in Report/DatabaseView  - Separate reports for Groups and Users

Group Report

Knowledge Base	Domain	Groups
KBA	global	GroupA
KBA	global	GroupB
KBA	global	GroupC

User Report

Knowledge Base	Domain	Users
KBA	global	UserA
KBA	global	UserB
KBA	global	UserC

@Ankur Bawiskar @Dr Atul G- LNG 

[Ankur Bawiskar]

@Raghu Ram Y 

you can create 2 database views if there is some common field etc

what did you start with and where are you stuck?

1st one joining 3 tables Knowledge Base, Domain, Groups

2nd one joining 3 tables Knowledge Base, Domain, User

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Raghu Ram Y]

No, all those fields are on the single table.

In a single table, we had three fields.. namely 

KnowledgeBase, Groups and Users...

[Raghu Ram Y]

Since groups and users are in list view, I stuck on how to proceed further.. @Ankur Bawiskar 

[Ankur Bawiskar]

@Raghu Ram Y 

you cannot separate directly.

Try to use function field in reporting

Report on function fields 

If my response helped please mark it correct and close the thread so that it benefits future readers.