Automatic Population of Related "Data"

[Manan]

I have faith that this is possible but I just don't know how to get where I need to be.

I am going through a software transition and need to get information from one into a specifically formatted excel document for the Integrator.

Column B is what I currently have, and Columns D thru H is what I'm trying to get to. I would do it manually, but there is over 300 Notifications rules and I want to learn a better way. Delimiter for joined cells would be a comma (","). Any help would be greatly appreciated!

 

[Manan]

Redacted - Example.xlsx
	A	B	C	D	E	F	G	H
1
2
3		Notification Rule		Notification Rule	Emails to notify (Users)	Statuses	Rooms	Event Types
4		….. - Aramark - Concession,from EMS Client and Virtual EMS		JBK2 - Aramark - Concession	….....@aramark.com,…......@aramark.com	Confirmed, Confirmed - Private, Tentative, Virtual EMS Request (Hold), Virtual EMS Request (No Hold), Web Conflict	…....... Stadium,Concourse,…..... Club,…..... Field,Cross Country/ The Pitch / Track and Field,Cross Country "The Range",Soccer Field,The Track,…..... Center,Arena,…..... Club Room,Parking lot,…..... Park,Softball Field,... Park,Baseball Field	(none),Academic Class,Advertising,Banquet,Breakfast,Camp,Ceremony,Clincial,Competition,Concert,Conference,Conference Call…....
5		Emails to notify
6		….....@aramark.com
7		…......@aramark.com
8		Statuses
9		Confirmed
10		Confirmed - Private
11		Tentative
12		Virtual EMS Request (Hold)
13		Virtual EMS Request (No Hold)
14		Web Conflict
15		Rooms
16		…....... Stadium
17		Concourse
18		…..... Club
19		…..... Field
20		Cross Country/ The Pitch / Track and Field
21		Cross Country "The Range"
22		Soccer Field
23		The Track
24		…..... Center
25		Arena
26		…..... Club Room
27		Parking lot
28		…..... Park
29		Softball Field
30		... Park
31		Baseball Field
32		Event Types
33		(none)
34		Academic Class
35		Advertising
36		Banquet
37		Breakfast
38		Camp
39		Ceremony
40		Clincial
41		Competition
42		Concert
43		Conference
44		Conference Call
45		Construction
46		Convention
47		Dance
48		Demonstration
49		Dinner
50		Exhibit
51		Exhibitor Table
52		FAC Dress Rehearsal
53		FAC Light Hang/Focus
54		FAC Programming
55		FAC Set Construction
56		FAC Sound Programming
57		FAC Technical Rehearsal
58		Fair
59		Final Exam
60		Full Facility
61		Game
62		Graduation
63		Hearing
64		Induction
65		Initiation
66		ITV/TTVN
67		Lecture
68		Livestock Show
69		Luncheon
70		Maintenance
71		Meeting
72		Orientation
73		Party
74		Performance
75		Practice
76		Presentation
77		Press Conference
78		Program
79		Reception
80		Recital
81		Registration
82		Rehearsal
83		Rodeo
84		Seminar
85		Social
86		Study Hall
87		Swimming Party
88		Testing
89		Tour
90		Tournament
91		Training
92		Vehicle Rental
93		Webex / Video Conf.
94		Wedding Ceremony
95		Wedding Reception
96		Workshop
97
98
99
100
Sheet1

Cell Formulas
Range	Formula
E4	E4	=TEXTJOIN(",",TRUE,B6:B7)
G4	G4	=TEXTJOIN(",",TRUE,B16:B31)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B96	Cell Value	contains "workshop"	text	NO