Merge multiple rows with same data

Brass Contributor

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. 

4/6/2023, 11:58:05 PM15198192183
4/6/2023, 11:57:23 PM15198192183
4/6/2023, 9:25:06 PM12267492027
4/6/2023, 9:19:37 PM12267492027
4/6/2023, 9:18:03 PM12267492027
4/6/2023, 9:15:44 PM12267492027
4/6/2023, 9:15:16 PM12267492027
4/6/2023, 6:26:43 PM14035423679
4/6/2023, 6:25:55 PM14035423679
1 Reply


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.

Merge multiple rows with same data.JPG