database cleanup

  1. M

    Moving Data into one Row Based on ID and First Mention

    <colgroup><col><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody> Individual ID Last Name First Record Postal Code Attribute Group Attribute Start Date Step 1 Date Step 2 Date2 Step 3 Date3 Step 4 Date4 34376725 Aaron 10/21/2010 35205 Grants Mill Growth Track _4 Dream...
  2. M

    Moving Data into one Row Based on ID and First Mention

    With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...
  3. B

    VBA to change cells containing specific text.

    I work with approx. 500 clients and use data from two different databases. Most of the client names match but about 100 do not. some of the mismatched names are very similar and some are not (a client changes their name, and only one of the databases registers the change). How can I write a...
  4. A

    Remove duplicates and merge rows-macro

    <tbody> A B C D E 2000 MaryP 123 street1,street2 2000 James S 123 street1 2000 Mary P 123 street1 2.8 2002 James S abc street1,street2 2003 Mary P abc street3,street4 1.8 </tbody> I have above data in excel.I have to select row1 and row3 as duplicates,as Column B name is same...

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