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 NameEEIDSchoolOfficeFloorCompanyChase1Harvard Chase1 Chicago23 Chase1 AppleChase1 GoogleJerry2Yale Jerry2Stanford Jerry2 Dallas10 Jerry2 New York18 Jerry2 AlteryxJerry2 Chick Fil A Desired Result NamePIDSchoolOfficeFloorCompanyChase1HarvardChicago23AppleChase1HarvardChicago23GoogleJerry2Yale Dallas10AlteryxJerry2Yale Dallas10Chick Fil AJerry2YaleNew York18AlteryxJerry2YaleNew York18Chick Fil AJerry2StanfordDallas10AlteryxJerry2StanfordDallas10Chick Fil AJerry2StanfordNew York18AlteryxJerry2StanfordNew York18Chick Fil A Any guidance would be greatly appreciated. Thank you in advanced -Chase

Matrix of all possible combinations from one database output.

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