Merging all duplicate rows content (in a specific column) in data table

Help Studio
, ,
1

Need some help:
how I can Merge all duplicate rows content (in a specific column) in data table

Capture

2

Hi,

Watch this video which help you to get duplicate rows in faster way => Combine Duplicate Row

Regards,
Rohit

3

hey, thank you very much.
however, i only need to merge the “Scope” Column

4

you can use my vba function
parameters:

  1. excel path
  2. Sheet name
  3. column to merge
    image
    image1163×432 24.5 KB

MergeDuplicateUtil.zip (26.0 KB)

Note:

  • MergeDuplicateUtil.xlsm = vba path
  • TestMerge.xaml xaml with example code
  • MergeDuplicatesTest.xlsx Example excel

Before
image

After
image