I would like to combine two cells, each cell contains line breaks and I would like to match the corresponding line:
Example below
Example below
Message ID | IB Recipient | Message Type | Priority | Send Instant | Last Completion Instant | Read Time | Output (Combine IB Recipient / Read Time) |
111111111 | Alejandro Cruz, RN Mike Jones, MD Carlos Escobar, MD | Staff Message | Routine | 7/1/2022 8:24 | 7/28/2022 10:22 | 10/05/2022 08:36:27 PM 07/28/2022 10:22:23 AM 07/05/2022 09:27:03 PM | Alejandro Cruz, RN | 10/05/2022 08:36:27 PM Mike Jones, MD | 07/28/2022 10:22:23 AM Carlos Escobar, MD | 07/05/2022 09:27:03 PM |
222222222 | Andres Liriano Ricardo Parra, MD Gerald Christopher | Staff Message | Routine | 7/1/2022 10:26 | 7/1/2022 10:31 | 07/01/2022 10:31:34 AM 07/01/2022 01:09:58 PM | Andres Liriano | Ricardo Parra, MD | 07/01/2022 10:31:34 AM Gerald Christopher | 07/01/2022 01:09:58 PM |
333333333 | Christopher Burdett, RN Andres Liriano Lia Guerrero, RN Gerald Christopher | Rx Response | Routine | 7/1/2022 17:54 | 7/5/2022 9:44 | 07/06/2022 11:43:19 AM 07/05/2022 09:44:50 AM 07/05/2022 10:09:16 AM | Christopher Burdett, RN | 07/06/2022 11:43:19 AM Andres Liriano | Lia Guerrero, RN |07/05/2022 09:44:50 AM Gerald Christopher |07/05/2022 10:09:16 AM |