multiple duplicate rows

  1. D

    Dynamically delete duplicate rows - leave no gaps

    Hi, I have a table (A2 = Names, B2 = Courses). There are multiple duplicate rows - where the information in both the A column and B column are exactly the same. I would like to re-create the table, but without any duplicate rows. There will be duplicates in the A column, and in the B column...
  2. S

    Multiple Duplicate Rows to Single unique Row (Combine multiple duplicate rows to one)

    Hi, I have a sheet with the data like below, can some one help me with a formula or something else to get the expected output? In my sheet i have a row with the same data multiple times, i need only one row with the same data and wanted to eliminate all duplicate rows and need same rule for...
    • signup
    • Thread
    • combine rows duplicate rows multiple duplicate rows
    • Replies: 5
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top