Turning Chronological List into a Table like report

[jconkl02]

I have a spreadsheet that I created last year that is basically a running history of every trouble ticket at my company. I received a lot of help with it from users on Mr.Excel message board and am always very thankful. Now I need help again.

I want to take the data that I export from our ticketing system every week and put it into a more table like format. Currently in a worksheet called "All_Events" each line represents a ticket changing from one status to another, so each ticket will have multiple lines during it's life. I want to make a worksheet called "Report" into a table that has one line per ticket and grabs certain events from "All_Events" and populates specific columns with the "Edit Date" value from that event

Below is what I am trying to capture (disregard row and column numbers for this list)

Question to MrExcel.xlsm
	E	F
8	Incident: Number	The Incident #
9	OPENED Date	Edit Date of First Occurance
10	REJECTED Date	Edit Date of First Occurance
11	ACCEPTED Date	Edit Date of First Occurance
12	ASSIGNED Date	Edit Date of First Occurance
13	RECOVERED Date	Edit Date of Last Occurance
14	RESOLVED Date	Edit Date of Last Occurance
15	CLOSED Date	Edit Date of Last Occurance
16	LAST STATUS	The value of INTO STATUS for the last event of each ticket
Report

...and this is the format that I want to put it in:

Question to MrExcel.xlsm
	A	B	C	D	E	F	G	H	I
1	Incident: Number	OPENED Date	REJECTED Date	ACCEPTED Date	ASSIGNED Date	RECOVERED Date	RESOLVED Date	CLOSED Date	LAST STATUS
2	Sample	First	First	First	First	Last	Last	Last
3	2095	1/3/2019 10:43		1/3/2019 11:53		1/3/2019 12:04	1/4/2019 22:54	6/12/2019 12:19	CLOSED
4	4004	6/6/2019 11:13		6/10/2019 10:30		6/18/2019 21:09	8/23/2019 16:59	2/7/2020 7:45	CLOSED
5	9471	4/28/2020 16:29			4/28/2020 16:29	4/28/2020 22:51	4/28/2020 17:45		RECOVERED
Report

The chronological list "All_Events" is almost 14000 lines I am not sure what the best way is to share that with the board. Here are the first few tickets:

Question to MrExcel.xlsm
	A	B	C	D	E	F	G
1	Incident: Number	Severity	Program	OUT OF Status	INTO Status	Edited By	Edit Date
2	2095	Severity 4	4G		OPENED	Theodore Page	1/3/2019 10:43
3	2095	Severity 4	4G	OPENED	ACCEPTED	Isaac Hernandez	1/3/2019 11:53
4	2095	Severity 4	4G	ACCEPTED	RECOVERED	George Walsh	1/3/2019 12:04
5	2095	Severity 4	4G	RECOVERED	RESOLVED	Cathy Barber	1/4/2019 22:54
6	2095	Severity 4	4G	RESOLVED	CLOSED	Ian Dennis	6/12/2019 12:19
7	2125	Severity 4	5G		OPENED	Kerry Adams	1/9/2019 9:43
8	2125	Severity 4	5G	OPENED	ACCEPTED	Marjorie Rhodes	1/9/2019 10:52
9	2125	Severity 4	5G	ACCEPTED	ASSIGNED	Alexis Ramos	1/9/2019 10:53
10	2125	Severity 4	5G	ASSIGNED	PENDING CUSTOMER	Kristin Leonard	1/10/2019 8:38
11	2125	Severity 4	5G	PENDING CUSTOMER	RECOVERED	Kelli Mills	2/12/2019 10:43
12	2125	Severity 4	5G	RECOVERED	RESOLVED	Daryl Ray	2/20/2019 17:29
13	2125	Severity 4	5G	RESOLVED	CLOSED	Teresa Mccarthy	3/5/2019 14:23
14	2149	Severity 4	5G		OPENED	Jaime Reed	1/11/2019 18:43
15	2149	Severity 4	5G	OPENED	ACCEPTED	Irma Maxwell	1/14/2019 9:25
16	2149	Severity 4	5G	ACCEPTED	ASSIGNED	Van Massey	1/14/2019 9:28
17	2149	Severity 4	5G	ASSIGNED	PENDING CUSTOMER	Geoffrey Blake	1/14/2019 9:32
18	2149	Severity 4	5G	PENDING CUSTOMER	RESOLVED	Flora Wilkerson	1/17/2019 17:28
19	2149	Severity 4	5G	RESOLVED	CLOSED	Genevieve Jones	1/18/2019 15:05
20	2155	Severity 4	5G		OPENED	Velma Parks	1/14/2019 11:21
21	2155	Severity 4	5G	OPENED	ACCEPTED	Donnie Briggs	1/14/2019 12:14
22	2155	Severity 4	5G	ACCEPTED	ASSIGNED	Frank Fowler	1/14/2019 13:35
23	2155	Severity 4	5G	ASSIGNED	RECOVERED	Leland Bryant	1/17/2019 10:40
24	2155	Severity 4	5G	RECOVERED	RESOLVED	Ronald Poole	1/17/2019 17:29
25	2155	Severity 4	5G	RESOLVED	CLOSED	Oscar Quinn	1/17/2019 17:37
26	2162	Severity 4	4G		OPENED	Tony Mccoy	1/15/2019 12:22
27	2162	Severity 4	4G	OPENED	ACCEPTED	Lewis Pope	1/15/2019 12:40
28	2162	Severity 4	4G	ACCEPTED	ASSIGNED	Kristen Butler	1/15/2019 12:41
29	2162	Severity 4	4G	ASSIGNED	PENDING CUSTOMER	Susan Doyle	1/15/2019 14:15
30	2162	Severity 4	4G	PENDING CUSTOMER	RECOVERED	Kendra Daniels	5/9/2019 9:03
31	2162	Severity 4	4G	RECOVERED	RESOLVED	Bert Richardson	7/2/2019 8:49
32	2162	Severity 4	4G	RESOLVED	CLOSED	Nathaniel Adkins	7/11/2019 14:44
33	2163	Severity 4	4G		OPENED	Anita Bush	1/15/2019 12:48
34	2163	Severity 4	4G	OPENED	ACCEPTED	Leslie Hardy	1/15/2019 12:52
35	2163	Severity 4	4G	ACCEPTED	ASSIGNED	Todd Austin	1/15/2019 12:53
36	2163	Severity 4	4G	ASSIGNED	PENDING CUSTOMER	Brandi Terry	1/15/2019 14:16
37	2163	Severity 4	4G	PENDING CUSTOMER	RESOLVED	Lora Harris	2/18/2019 22:39
38	2163	Severity 4	4G	RESOLVED	CLOSED	Felicia Fisher	3/8/2019 8:59
39	2165	Severity 3	5G		OPENED	Jorge Gomez	1/16/2019 10:55
40	2165	Severity 3	5G	OPENED	ASSIGNED	Sharon Barnett	1/16/2019 13:58
41	2165	Severity 3	5G	ASSIGNED	PENDING CUSTOMER	Lester Harmon	1/16/2019 14:01
42	2165	Severity 3	5G	PENDING CUSTOMER	RECOVERED	Alonzo Dixon	2/20/2019 16:53
43	2165	Severity 3	5G	RECOVERED	RESOLVED	Tonya Townsend	2/20/2019 17:29
44	2165	Severity 3	5G	RESOLVED	CLOSED	Paula Schwartz	2/20/2019 17:29
45	2167	Severity 4	4G		OPENED	Malcolm Hammond	1/16/2019 13:03
46	2167	Severity 4	4G	OPENED	ACCEPTED	Dianna West	1/22/2019 23:05
47	2167	Severity 4	4G	ACCEPTED	ASSIGNED	Frances Jordan	1/22/2019 23:21
48	2167	Severity 4	4G	ASSIGNED	PENDING CUSTOMER	Raymond Dean	1/28/2019 11:00
49	2167	Severity 4	4G	PENDING CUSTOMER	ASSIGNED	Jo Byrd	1/30/2019 13:51
50	2167	Severity 4	4G	ASSIGNED	PENDING CUSTOMER	Jason Manning	2/27/2019 14:28
51	2167	Severity 4	4G	PENDING CUSTOMER	ASSIGNED	Alfred Martinez	3/1/2019 9:57
52	2167	Severity 4	4G	ASSIGNED	RESOLVED	Theodore Page	3/5/2019 9:23
53	2167	Severity 4	4G	RESOLVED	CLOSED	Isaac Hernandez	3/5/2019 9:45
54	2169	Severity 4	4G		OPENED	George Walsh	1/17/2019 5:59
55	2169	Severity 4	4G	OPENED	ACCEPTED	Cathy Barber	1/17/2019 8:02
56	2169	Severity 4	4G	ACCEPTED	ASSIGNED	Ian Dennis	1/17/2019 8:03
57	2169	Severity 4	4G	ASSIGNED	RECOVERED	Kerry Adams	3/4/2019 13:09
58	2169	Severity 4	4G	RECOVERED	RESOLVED	Marjorie Rhodes	5/15/2019 15:35
59	2169	Severity 4	4G	RESOLVED	CLOSED	Alexis Ramos	7/11/2019 14:45
60	2170	Severity 4	4G		OPENED	Kristin Leonard	1/17/2019 7:04
61	2170	Severity 4	4G	OPENED	ACCEPTED	Kelli Mills	1/17/2019 8:05
62	2170	Severity 4	4G	ACCEPTED	ASSIGNED	Daryl Ray	1/17/2019 8:06
63	2170	Severity 4	4G	ASSIGNED	RECOVERED	Teresa Mccarthy	3/12/2019 10:15
64	2170	Severity 4	4G	RECOVERED	RESOLVED	Jaime Reed	5/21/2019 23:37
65	2170	Severity 4	4G	RESOLVED	CLOSED	Irma Maxwell	7/11/2019 14:45
66	2177	Severity 4	5G		OPENED	Van Massey	1/17/2019 15:02
67	2177	Severity 4	5G	OPENED	ASSIGNED	Geoffrey Blake	1/18/2019 9:11
68	2177	Severity 4	5G	ASSIGNED	PENDING CUSTOMER	Flora Wilkerson	1/18/2019 9:14
69	2177	Severity 4	5G	PENDING CUSTOMER	RESOLVED	Genevieve Jones	1/28/2019 15:45
70	2177	Severity 4	5G	RESOLVED	CLOSED	Velma Parks	1/28/2019 15:45
71	2220	Severity 4	5G		OPENED	Donnie Briggs	1/24/2019 7:58
72	2220	Severity 4	5G	OPENED	ACCEPTED	Frank Fowler	1/24/2019 9:16
73	2220	Severity 4	5G	ACCEPTED	ASSIGNED	Leland Bryant	1/24/2019 9:47
74	2220	Severity 4	5G	ASSIGNED	RECOVERED	Ronald Poole	1/25/2019 0:32
75	2220	Severity 4	5G	RECOVERED	RESOLVED	Oscar Quinn	1/28/2019 15:45
76	2220	Severity 4	5G	RESOLVED	CLOSED	Tony Mccoy	3/8/2019 13:45
77	2230	Severity 4	5G		OPENED	Lewis Pope	1/24/2019 19:32
78	2230	Severity 4	5G	OPENED	ACCEPTED	Kristen Butler	1/25/2019 0:09
79	2230	Severity 4	5G	ACCEPTED	ASSIGNED	Susan Doyle	1/25/2019 0:13
80	2230	Severity 4	5G	ASSIGNED	PENDING CUSTOMER	Kendra Daniels	1/25/2019 0:31
81	2230	Severity 4	5G	PENDING CUSTOMER	RECOVERED	Bert Richardson	3/12/2019 10:58
82	2230	Severity 4	5G	RECOVERED	RESOLVED	Nathaniel Adkins	4/23/2019 13:45
83	2230	Severity 4	5G	RESOLVED	CLOSED	Anita Bush	6/3/2019 14:13
84	2235	Severity 4	4G		OPENED	Leslie Hardy	1/26/2019 10:54
85	2235	Severity 4	4G	OPENED	ASSIGNED	Todd Austin	1/26/2019 10:55
86	2235	Severity 4	4G	ASSIGNED	RESOLVED	Brandi Terry	3/11/2019 17:55
87	2235	Severity 4	4G	RESOLVED	CLOSED	Lora Harris	3/11/2019 17:55
88	2235	Severity 4	4G	CLOSED	ASSIGNED	Felicia Fisher	3/11/2019 17:55
89	2235	Severity 4	4G	ASSIGNED	RESOLVED	Jorge Gomez	3/12/2019 8:46
90	2235	Severity 4	4G	RESOLVED	CLOSED	Sharon Barnett	3/12/2019 8:46
91	2250	Severity 4	4G		OPENED	Lester Harmon	1/29/2019 13:13
92	2250	Severity 4	4G	OPENED	ACCEPTED	Alonzo Dixon	1/29/2019 15:32
93	2250	Severity 4	4G	ACCEPTED	ASSIGNED	Tonya Townsend	1/29/2019 15:32
94	2250	Severity 4	4G	ASSIGNED	RECOVERED	Paula Schwartz	1/29/2019 15:36
95	2250	Severity 4	4G	RECOVERED	RESOLVED	Malcolm Hammond	2/20/2019 16:41
96	2250	Severity 4	4G	RESOLVED	CLOSED	Dianna West	3/8/2019 8:10
All_Events

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:E13898	Cell Value	contains "PENDING CUSTOMER"	text	NO
D1:E13898	Cell Value	contains "CLOSED"	text	NO
D1:E13898	Cell Value	contains "OPENED"	text	NO