All Possible Combinations basis on Condition

[sg2209]

Hi All,

struggling with something very important and also watched videos and been to severa forums however not understanding how to do it.

please help me with all the possible combinations with conditions i have 4 columns with List and 5 colunms for Type/Pyr. i am trying to make all combiantions for Firts Type

Example

List1	List 2	List 3	List 4	Type
G0480	82570		80307	AMGRP

Expectations in 2 columns only

List 1	List 2	Type
G0480	82570​	AMGRP
G0480	80307​	AMGRP
82570​	80307​	AMGRP

and i have 500 + rows where


I have also attached the sheet for better understanding and highlighted in green what is required

 

[sg2209]

Possible Comb.xlsx
	A	B	C	D	E	F	G	H	I	J
1	List1	List 2	List 3	List 4	Type			List 1	List 2	Type
2	G0480	82570		80307	AMGRP			G0480	82570	AMGRP
3	81001	84156		G0480	AMGRP			G0480	80307	AMGRP
4	84460			80053	AMGRP			82570	80307	AMGRP
5	83498			80402	AMGRP			81001	84156	AMGRP
6	80500			82785	AMGRP			81001	G0480	AMGRP
7	84460	84450	80048	80050/80053	BCBS			84156	G0480	AMGRP
8	87625	87798		81220 /81243	BCBS			84460	80053	AMGRP
9	83718			80061 / 82465	BCBS			83498	80402	AMGRP
10	82565	84450	84460	80053	BCBS			80500	82785	AMGRP
11	86709	86803	87340	80076	BCBS			84460	84450	BCBS
12	82310			82330	BCBS			84460	80048	BCBS
13	87045			87046	BCBS			84460	80050	BCBS
14	88342			88323	BCBS			84460	80053	BCBS
15	87625			87800	BCBS			84450	80048	BCBS
16	G0481			80307	BSENY			84450	80050	BCBS
17	88271	88275	88291	81403	Emblem			84450	80053	BCBS
18	87491			87591	Emblem
19	87625			81401	EMBLEM
20	87625			86747	EMBLEM
21	81222			81220	EMBLEM
22	81243			81228	EMBLEM
23	84100			83718	Emblem
24	87493			87507	Emblem
25	84436	84479	84476	84439	General
26	86355	86359	86360	88184	GHI
27	88112			80050 or 80053	GHI
28	83550			83540	GHI
29	88291			81507	GHI
30	86357			88184	GHI
31	81228			81265	GHI
32	84478			80061	GW
33	87206			87798	GW
34	87591	87661		81243	Health First
35	87625			87624	HIP
36	82533			80050	HIP
37	87800			81220	HIP
38	87086			87081	HIP
39	82951			85027	HIP
40	80076			84075	HIP
41	82553			80048	HIP
42	81003			81001	HIP
43	80051			80053	HIP
44	87517			G0499	HIP
45	80048			80053	HIP
46	81206, 81207			G0452	HLTHF5196	A
47	85049			85025	HLTHF5196
48	88291			81507	HLTHF5196
49	G0145			88142	HLTHF5196
50	81406	81408		81228	HPLUS
51	87591	87491		81220	Hplus
52	87491	87591	87624	81220	Hplus
53	88291			81288	HPLUS
54	87661			87801	HPLUS
55	87491	88271		81243	LOC1199
56	88341			88360	LOC1199
57	83036			82985	LOC1199
58	80500			82550	LOC1199
59	88175			88112	LOC1199
60	87798			81220	LOC1199
61	87521			82947	LOC1199
62	83550			84466	LOCAL1199
63	84443, 85007, 85027		80053	80050	Mplus	A
64	80076			80053 / 84443	UHC	A
65	81290	81255	81251	81401	UHC
66	87081			87086	UHC
67	87081			87040	UHC
68	88341			88360	UHC
69	87798			G0145	UHC
70	85014			80050	UHC
71	86316			86300	UHCNY
72	83550			83540	UMR
73	87491			85610
Sheet1