+ Reply to Thread
Results 1 to 6 of 6

Organizing pattern in excel

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Organizing pattern in excel

    Hi!

    I have a table with 16 columns and 1000 rows. In this table there is a pattern, say:

    4F B1 6C 4E
    01 00 00 00 01 4F B1 6C 51 01 00 00 00 04 4F B1
    6C 54 01 00 00 00 00 4F B1 6C 57 01 00 00 00 03 etc. etc.

    The pattern is: 4F B1 6C 4E, 4F B1 6C 51, 4F B1 6C 54, 4F B1 6C 57
    01 , 01 , 01 , 01
    00 00 00 01, 00 00 00 04, 00 00 00 00, 00 00 00 03

    Instead of being randomly placed, I want to have all the "4F B1 6C 4E" beneath each other in a new column, all the "01" beneath each other a new column and all the "00 00 00 01" beneath each other in a new column. The new table only have three columns!

    Unfortunately, I don't know how to do this. Any ideas? Any suggestions will be highly appreciated!

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Organizing pattern in excel

    Please upload a sample worksheet along with desired results
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Organizing pattern in excel

    Sure, will do, but how?

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Organizing pattern in excel

    On replying, click on the "go advanced" tab on the right-bottom of the screen. You would then be able to upload files

  5. #5
    Registered User
    Join Date
    07-05-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Organizing pattern in excel


  6. #6
    Registered User
    Join Date
    07-05-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Organizing pattern in excel

    Anyone who can help me?

+ Reply to Thread

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