Results 1 to 12 of 12

Need help grouping by similar words in second column

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2011
    Location
    hudsonville, michigan
    MS-Off Ver
    Excel 2007
    Posts
    10

    Need help grouping by similar words in second column

    First off I'd like to thank the knowledgeable people here who take time to help guys like me out. It is really appreciated

    images below

    http://img219.imageshack.us/img219/738/excel1.jpg
    http://img32.imageshack.us/img32/499...4nov191730.jpg

    What I am trying to do is insert a blank row and also the ~ symbol (or any character) at the point that the words change in the second column.

    I hope it's apparent what I need to do here, if any questions please ask. It should be obvious after looking at the pics.

    I have a list of over 100k keywords to sort this way and doing it manually will be a chore.

    Please help if you can.
    Thanks!
    Attached Files Attached Files
    Last edited by bigmark1972; 11-19-2011 at 07:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1