Apr 10 2023 01:00 PM
I need to merge multiple rows that have the same number in column B. Please see below. For example I need to merge rows 1 and 2 in column B and rows 3-7 in column B and so on. so that column A data still remains on separate rows but column B will only count the phone number 1 time.
A | B |
4/6/2023, 11:58:05 PM | 15198192183 |
4/6/2023, 11:57:23 PM | 15198192183 |
4/6/2023, 9:25:06 PM | 12267492027 |
4/6/2023, 9:19:37 PM | 12267492027 |
4/6/2023, 9:18:03 PM | 12267492027 |
4/6/2023, 9:15:44 PM | 12267492027 |
4/6/2023, 9:15:16 PM | 12267492027 |
4/6/2023, 6:26:43 PM | 14035423679 |
4/6/2023, 6:25:55 PM | 14035423679 |
Apr 10 2023 02:44 PM
Maybe with Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.