Results 1 to 10 of 10

Cleaning Up Data with Multiple Variation

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    kl
    MS-Off Ver
    Excel 2007
    Posts
    29

    Cleaning Up Data with Multiple Variation

    Hi Guys,
    Really appreciate your help on the issue that I am facing when working with my dataset.

    There are variations of my current data in one column (as below). And I need to segregate the column between the Title (AM1) with the Role (Role AAAA etc). Tried using the text to column function, but due to the variation of entries formatting and Title convention - can't do it.

    AM 1 ROLE AAAA
    AM 2 ROLE AAA
    AM 2 ROLE B
    AM 2 ROLE B
    AM 2, ROLE BBBBBB
    AM 2-ROLE BBBB
    AM 2,ROLE BB
    AM 2 - ROLE

    The outcome intended from above is as below (in 2 different column)

    Title Role
    AM1 ROLE AAAA
    AM2 ROLE AAA
    AM2 ROLE B
    AM2 ROLE B
    AM2 ROLE BBBBBB
    AM2 ROLE BBBB
    AM2 ROLE BB
    AM2 ROLE
    ACTING HEAD ROLE A
    ACTING HEAD ROLE A
    ACTING HEAD ROLE B
    ACTING HEAD ROLE B
    ACTING HEAD ROLE B
    ACTING HEAD ROLE B
    ACTING HEAD ROLE B
    ACTING HEAD ROLE
    SVP ROLE A
    SVP ROLE A
    SVP ROLE B
    SVP ROLE B
    SVP ROLE B
    SVP ROLE B
    SVP ROLE B
    SVP ROLE

    Thanks in advance for your help.

    Cheers
    Bert.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-18-2014, 10:36 AM
  2. Cleaning Multiple Sheets Across Time.
    By Insert Name in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2014, 11:08 PM
  3. Replies: 6
    Last Post: 02-08-2014, 05:01 AM
  4. [SOLVED] Cleaning and Consolidating Multiple Worksheets
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-31-2012, 11:01 AM
  5. Cleaning and sorting data to multiple worksheets
    By rmf17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2012, 08:10 AM
  6. Increase the data variation range
    By jdbaba in forum Excel General
    Replies: 2
    Last Post: 11-04-2011, 01:18 PM
  7. Data validation variation
    By RyanNIF in forum Excel General
    Replies: 1
    Last Post: 08-03-2010, 01:24 PM

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