Combine cells based on ending and intermediate values.

[Ralph1024]

I am looking for a way to combine cells based on similar values.
For example, in the following screenshot, if column A has a similar ending value 64B-20H2"A" and 64B-20H2"B", these would combine into 64B-20-H2A/B (column B) as long as their names match in column C.

I am now looking to see if there is a way to combine rows 12-17 so that it reads like the second screenshot. The current formula in column B combines based on the last character of the Column A and a matching name in Column C.

Does anyone have any have an idea on how to pursue this? Any feedback is greatly appreciated.


Screenshot 1

Screenshot 2

Combining Cells.xlsx
	A	B	C
1	ID	Combined ID's	Name
2	64B-20-H2A	64B-20-H2A/B	Heater
3	64B-20-H2B		Heater
4	64B-20-P3A	64B-20-P3A/B	Pump
5	64B-20-P3B		Pump
6	64B-20-PM3A	64B-20-PM3A/B	Pump Motor
7	64B-20-PM3B		Pump Motor
8	64B-20-Z2-P1A	64B-20-Z2-P1A/B	WESP
9	64B-20-Z2-P1B		WESP
10	64B-20-Z2-PM1A	64B-20-Z2-PM1A/B	WESP Recycle
11	64B-20-Z2-PM1B		WESP Recycle
12	64E-20A-M1	64E-20A-M1/2	Fan Motor
13	64E-20A-M2		Fan Motor
14	64E-20B-M1	64E-20B-M1/2	Fan Motor
15	64E-20B-M2		Fan Motor
16	64E-20C-M1	64E-20C-M1/2	Fan Motor
17	64E-20C-M2		Fan Motor
Sheet1

Cell Formulas
Range	Formula
B2:B17	B2	=IF(ROWS(B$2:B2)=MATCH(LEFT(A2,LEN(A2)-1)&"|"&C2,LEFT(A$2:A$17,LEN(A$2:A$17)-1)&"|"&C$2:C$17,),LEFT(A2,LEN(A2)-1)&TEXTJOIN("/",,FILTER(RIGHT(A$2:A$17,1),(LEFT(A$2:A$17,LEN(A$2:A$17)-1)=LEFT(A2,LEN(A2)-1))*(C$2:C$17=C2))),"")