Summarize multiple rows of text data

**lllr** · 07-16-2014, 03:41 PM

I am trying to summarize rows of data to show a list of unique values only between a "start" and "end" rows.

Here is what it should list on the "end" row (highlighted in yellow). Yes there are also lots of Blanks but that should not be part of the summary.

For example, if the rows from "Start" to "End" are all STUDENT A, then I need the value to be STUDENT A. If there are a mix of STUDENT A and STUDENT B, then "End" should be "STUDENT A, STUDENT B".

Test UTC_Time DNT
Test Start 5/29/2014 15:42:45.04
Test 5/29/2014 15:42:45.34
Test 5/29/2014 15:42:50.00 STUDENT A
Test 5/29/2014 15:42:55.02 STUDENT A
Test 5/29/2014 15:43:00.02 STUDENT A
Test 5/29/2014 15:43:05.02 STUDENT A
Test 5/29/2014 15:43:09.45
Test 5/29/2014 15:43:10.02 STUDENT A
Test 5/29/2014 15:43:10.62
Test 5/29/2014 15:43:15.02 STUDENT A
Test 5/29/2014 15:43:20.02 STUDENT A
Test 5/29/2014 15:43:25.01 STUDENT A
Test 5/29/2014 15:43:30.02 STUDENT A
Test 5/29/2014 15:43:35.01 STUDENT A
Test 5/29/2014 15:43:40.03 STUDENT A
Test 5/29/2014 15:43:42.20
Test 5/29/2014 15:43:45.01 STUDENT A
Test 5/29/2014 15:43:50.03 STUDENT A
Test 5/29/2014 15:43:55.01 STUDENT A
Test 5/29/2014 15:43:58.73
Test 5/29/2014 15:44:00.02 STUDENT A
Test 5/29/2014 15:44:05.02 STUDENT A
Test 5/29/2014 15:44:07.90
Test 5/29/2014 15:44:10.02 STUDENT A
Test 5/29/2014 15:44:12.80
Test 5/29/2014 15:44:15.02 STUDENT A
Test 5/29/2014 15:44:19.68
Test 5/29/2014 15:44:20.02 STUDENT A
Test 5/29/2014 15:44:21.24
Test 5/29/2014 15:44:25.00 STUDENT A
Test 5/29/2014 15:44:30.02 STUDENT A
Test 5/29/2014 15:44:31.10
Test End 5/29/2014 15:44:34.08 STUDENT A
Test Start 5/29/2014 15:54:45.01
Test 5/29/2014 15:54:45.01 STUDENT A
Test 5/29/2014 15:54:45.26
Test 5/29/2014 15:54:50.00 STUDENT A
Test 5/29/2014 15:54:55.01 STUDENT A
Test 5/29/2014 15:54:59.01
Test 5/29/2014 15:55:00.00 STUDENT A
Test 5/29/2014 15:55:05.01 STUDENT B
Test 5/29/2014 15:55:10.01 STUDENT A
Test 5/29/2014 15:55:13.23
Test 5/29/2014 15:55:15.01 STUDENT A
Test 5/29/2014 15:55:18.93
Test 5/29/2014 15:55:20.00 STUDENT A
Test 5/29/2014 15:55:21.63
Test 5/29/2014 15:55:22.47
Test 5/29/2014 15:55:25.00 STUDENT A
Test 5/29/2014 15:55:30.01 STUDENT A
Test 5/29/2014 15:55:35.00 STUDENT A
Test 5/29/2014 15:55:37.66
Test 5/29/2014 15:55:40.00 STUDENT A
Test 5/29/2014 15:55:45.01 STUDENT A
Test 5/29/2014 15:55:48.79
Test 5/29/2014 15:55:50.01 STUDENT A
Test 5/29/2014 15:55:52.42
Test 5/29/2014 15:55:55.01 STUDENT A
Test 5/29/2014 15:55:55.83
Test 5/29/2014 15:55:56.99
Test 5/29/2014 15:55:57.55
Test 5/29/2014 15:55:59.03
Test 5/29/2014 15:56:00.01 STUDENT A
Test 5/29/2014 15:56:05.00 STUDENT A
Test 5/29/2014 15:56:10.01 STUDENT A
Test 5/29/2014 15:56:10.94
Test 5/29/2014 15:56:15.01 STUDENT A
Test 5/29/2014 15:56:18.60
Test 5/29/2014 15:56:20.01 STUDENT A
Test 5/29/2014 15:56:21.19
Test 5/29/2014 15:56:25.01 STUDENT A
Test 5/29/2014 15:56:26.88
Test 5/29/2014 15:56:28.09
Test 5/29/2014 15:56:30.01 STUDENT A
Test End 5/29/2014 15:56:31.06 STUDENT A, STUDENT B