Results 1 to 6 of 6

Thread: Advanced delimit?

  1. #1

    Advanced delimit?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey! How can I delimit a file but be able to create uniform columnvalues from data?
    Change file from this:
    cat;dog;bird
    bird;dog;horse;cat
    bird;cat;dog;horse
    To this:
    cat dog bird horse
    cat dog bird horse
    cat dog bird horse

    Any help is greatly appreciated. I think there may be a formula that could work?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Data>Text To Columns

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    Data>Text To Columns

    It's more than just delimiting the file. After delimiting, I need each unique entry to line up into it's own column, not scattered as it would be initally.

  4. #4
    Quote Originally Posted by jmp14 View Post
    It's more than just delimiting the file. After delimiting, I need each unique entry to line up into it's own column, not scattered as it would be initally.
    The only thing I can think of so far is to review each column and make new columns with an IF function. . .if cell "A2" is cat then cat, if not than null. And then remove the nulls. . .

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    is this help you ?
    Attached Files Attached Files

  6. #6
    Quote Originally Posted by sambit View Post
    Hi,
    is this help you ?
    Yes I think this might work great! I will try it on my larger file and let you know.

Posting Permissions

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