Spreadsheet: 585951d1534106555-searching-through-a-range-for-a-specific-text-and-having-it-out-into-a-different-cell-example-data-to-search-through
Sheet: Sheet1

Data
SKU | Status 1 | Status 2 | Status 3 | Status 4 | Status 5 | Status 6 | Status 7 | Status 8 | Status 9 | Status 10 | Status 11 | Status 12 | Status 13 | Status 14 |  | Accepted | Invoiced
AA1 | 2018-06-04T09:27:55.576 -> Modelling in Progress | 2018-06-04T16:50:42.591 -> Ready for QA Internal | 2018-06-05T15:16:48.729 -> QA Customer | 2018-06-22T09:18:15.880 -> Accepted | 2018-07-03T03:41:58.683 -> Invoiced
AA2 | 2018-06-12T15:53:47.172 -> Modelling in Progress | 2018-06-12T18:25:29.705 -> Ready for QA Internal | 2018-06-13T16:17:16.151 -> QA Customer | 2018-06-14T17:13:46.612 -> RE Customer | 2018-06-19T14:01:51.814 -> Ready for QA Internal | 2018-06-19T16:16:09.055 -> QA Customer | 2018-06-20T15:45:41.958 -> RE Customer | 2018-06-21T09:36:03.737 -> Ready for QA Internal | 2018-06-21T10:02:15.630 -> QA Customer | 2018-06-21T13:02:19.639 -> Accepted | 2018-07-03T03:42:02.343 -> Invoiced
AA3 | 2018-05-31T14:23:44.266 -> Cancelled | 2018-05-31T16:54:34.141 -> Open | 2018-06-15T09:10:40.320 -> Modelling in Progress | 2018-06-19T16:36:28.780 -> Ready for QA Internal | 2018-06-19T18:38:00.964 -> QA Customer | 2018-06-20T13:13:02.565 -> RE Customer | 2018-06-21T16:28:56.633 -> Ready for QA Internal | 2018-06-21T18:31:42.688 -> QA Customer | 2018-06-25T13:03:40.848 -> RE Customer | 2018-06-25T16:10:29.672 -> Ready for QA Internal | 2018-06-25T17:56:27.975 -> QA Customer | 2018-06-28T14:58:03.923 -> RE Customer | 2018-06-29T15:50:43.939 -> Ready for QA Internal | 2018-06-29T17:39:37.129 -> QA Customer
AA4 | 2018-05-31T14:23:46.771 -> Cancelled | 2018-05-31T16:54:34.570 -> Open | 2018-06-14T10:51:01.992 -> Invalid | 2018-06-19T09:41:24.600 -> Needs Work | 2018-06-21T16:01:59.492 -> Modelling in Progress | 2018-06-22T15:23:59.766 -> Ready for QA Internal | 2018-06-22T18:11:58.594 -> Ready for QA Internal | 2018-06-22T18:52:44.785 -> QA Customer | 2018-06-26T13:33:14.416 -> RE Customer | 2018-06-29T17:31:37.502 -> Ready for QA Internal | 2018-06-29T18:29:32.199 -> QA Customer | 2018-07-02T09:17:51.186 -> RE Customer | 2018-07-04T11:17:53.759 -> Ready for QA Internal | 2018-07-04T13:41:44.101 -> QA Customer
AA5 | 2018-06-08T11:08:16.575 -> Modelling in Progress | 2018-06-08T19:24:26.175 -> Ready for QA Internal | 2018-06-12T17:42:08.533 -> QA Customer | 2018-06-14T09:19:47.147 -> RE Customer | 2018-06-14T13:49:20.539 -> Ready for QA Internal | 2018-06-15T15:49:45.263 -> QA Customer | 2018-06-19T09:18:33.666 -> RE Customer | 2018-06-19T14:16:27.265 -> Ready for QA Internal | 2018-06-19T17:10:41.817 -> QA Customer | 2018-06-20T13:12:09.614 -> Accepted | 2018-07-03T03:38:44.057 -> Invoiced
AA6 | 2018-06-01T09:28:37.405 -> Modelling in Progress | 2018-06-14T13:23:09.656 -> Ready for QA Internal | 2018-06-14T18:45:28.813 -> QA Customer | 2018-06-15T14:57:21.041 -> RE Customer | 2018-06-19T10:38:56.781 -> Ready for QA Internal | 2018-06-19T17:18:12.370 -> QA Customer | 2018-06-21T10:09:44.134 -> RE Customer | 2018-06-21T10:57:06.014 -> Ready for QA Internal | 2018-06-21T16:25:13.657 -> QA Customer | 2018-06-25T13:04:04.007 -> Accepted | 2018-07-03T03:41:57.779 -> Invoiced
AA2 | ??
AA1 | ??
AA4 | ?? |  |  |  |  | How to show it
AA3 | ?? |  |  |  |  | SKU | Status1 | Accepted | Invoiced
AA6 | ?? |  |  |  |  | AA1 | 2018-06-04T09:27:55.576 -> Modelling in Progress | 2018-06-22T09:18:15.880 -> Accepted | 2018-07-03T03:41:58.683 -> Invoiced
AA5 | ?? |  |  |  |  | AA2 | 2018-06-12T15:53:47.172 -> Modelling in Progress | 2018-06-21T13:02:19.639 -> Accepted | 2018-07-03T03:42:02.343 -> Invoiced
 |  |  |  |  |  | AA3 | 2018-05-31T14:23:44.266 -> Cancelled
 |  |  |  |  |  | AA4 | 2018-05-31T14:23:46.771 -> Cancelled
 |  |  |  |  |  | AA5 | 2018-06-08T11:08:16.575 -> Modelling in Progress | 2018-06-20T13:12:09.614 -> Accepted | 2018-07-03T03:38:44.057 -> Invoiced
 |  |  |  |  |  | AA6 | 2018-06-01T09:28:37.405 -> Modelling in Progress | 2018-06-25T13:04:04.007 -> Accepted | 2018-07-03T03:41:57.779 -> Invoiced
 |  |  |  |  |  | My Solution
 |  |  |  |  |  | SKU | Status 1 | Accepted | Invoiced