Results 1 to 8 of 8

Rearrange different numbers from different rows in one row and in consecutive columns

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    3

    Rearrange different numbers from different rows in one row and in consecutive columns

    Hi excel experts,hv a question hope someone can help me...
    i need to rearrange different numbers from different rows into one row and in consecutive columns
    current aspect of my table:
    0 1 2 3 4 5 7 8 10
    TSE1 TBE1 TNM1 TST1 TBE2 TSMF TTM1 TNMF TSE2
    X

    6 11 12 13 14 16 17 18 20 21 22 23 24 25 26 27 28 39 50 51 52 58
    CS07 CB80 CS80 CT61(37) CL80 CS81 CS03 CS01 CS04 DT30 CS12 CB07 CC37 AB01 RB01 CC30 CC54 AL16 PS01 PS02 PS03 CC61
    x

    15 45 46 47 49 53 54 55 61 63 64 65 66 67 68 69 83 93 94
    CS05 GP01 GP02 PP01 PS04 QP01 QS02 QS03 AS12 AC37 AP16 AP26 DT28 AL20 GP03 FSZ3 GP04 RP01 RP02
    x

    29 30 31 32 33 34 35 36 37 41 42 60 62 95 96 99
    ER02 NM60 ED09 EP01 EN12 EM02 ER01 ENMX EM03 EM82 EM61 FEP9 EP02 EHT1 EBP1 EHM1
    X X X
    desired result:
    2 6 30 31 32 61

    is that possible ?
    plz find attached an example file
    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: 3
    Last Post: 06-27-2013, 08:03 AM
  2. Rows of Users to rearrange in Columns
    By dgdamay in forum Excel General
    Replies: 3
    Last Post: 09-18-2012, 07:28 AM
  3. Fill columns with formulas containing non-consecutive numbers
    By dmva in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-09-2010, 05:20 PM
  4. Rearrange info in rows to columns - HELP!
    By LaVerne in forum Excel General
    Replies: 0
    Last Post: 06-20-2005, 04:40 PM
  5. Rearrange info in rows to columns - HELP!
    By LaVerne in forum Excel General
    Replies: 0
    Last Post: 06-20-2005, 04:39 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