Matrix of all possible combinations from one database output.

[Cwolfle15]

I have a requirement and I have been spinning my wheels for days. I need to create a unique row(s) for all possible possibilities for each person. See below for example.

DATA FROM DB

Name	EEID	School	Office	Floor	Company
Chase	1	Harvard
Chase	1		Chicago	23
Chase	1				Apple
Chase	1				Google
Jerry	2	Yale
Jerry	2	Stanford
Jerry	2		Dallas	10
Jerry	2		New York	18
Jerry	2				Alteryx
Jerry	2				Chick Fil A

Desired Result

Name	PID	School	Office	Floor	Company
Chase	1	Harvard	Chicago	23	Apple
Chase	1	Harvard	Chicago	23	Google
Jerry	2	Yale	Dallas	10	Alteryx
Jerry	2	Yale	Dallas	10	Chick Fil A
Jerry	2	Yale	New York	18	Alteryx
Jerry	2	Yale	New York	18	Chick Fil A
Jerry	2	Stanford	Dallas	10	Alteryx
Jerry	2	Stanford	Dallas	10	Chick Fil A
Jerry	2	Stanford	New York	18	Alteryx
Jerry	2	Stanford	New York	18	Chick Fil A

Any guidance would be greatly appreciated.

Thank you in advanced

-Chase

[Hadzramin_Rahman · Accepted solution]

This the result that I got. Please verify.

The workflow is attached.

Workflow

Result

[NicholasM]

Hey @Cwolfle15 ,

I got the same result as @Hadzramin_Rahman. Just using the Summarize tool instead of Unique. Great minds think alike. 

[Hadzramin_Rahman]

Cool @NicholasM 

[Cwolfle15]

Thank you so much!!