Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    13

    Red face Unanswered: Different columns according to value horizontally

    Hai there... I never actually used Excel.. and i know my question will sound a bit stupid.. But i really do not know.. and i hope someone can teach me..

    I have thousands of data..and some of them look like this..

    Sender, SendMessage, Reason (column name)
    60111, WIN 22, successful!
    60122, WIN aaa, invalid msg format!
    60133, win 62, win prize!
    60144, win 92, successful!
    60155, WIN 82, successful!
    60166, WIN 44, invalid msg format!
    60177, Win 42, win prize!
    60188, wIn 59, invalid msg format!
    60199, wiN 16, successful!

    and i need to seperate each data into different columns (horizontally) like if the Reason is successful, the all data that is successful will be in successful column..

    the desired output will look like this.. in excel

    60111, WIN 22, successful! 60122, WIN aaa, invalid msg format! 60133, win 62, win prize!
    60144, win 92, successful! 60166, WIN 44, invalid msg format! 60177, Win 42, win prize!
    60155, WIN 82, successful! 60188, wIn 59, invalid msg format!
    60199, wiN 16, successful!

    and apart from that, i also need to sort my column (SMSSend) in ascending way... please help...

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. On the Menu at the top, choose Data > Text to Column
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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