Results 1 to 4 of 4

Thread: Order to rows in the same way

  1. #1
    Seeker Bine's Avatar
    Join Date
    Dec 2020
    Posts
    9
    Articles
    0
    Excel Version
    Excel 2016

    Order to rows in the same way



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

    Dear all,

    I have the following problem and I just cant find a way to do it:

    Example:


    PHP Code:
    Row 1  tree cherry chair house

    Row 2  house cherry tree chair
    Row 3  34       32      33   56 
    Row 2 and 3 belong together.
    I need to get row 1 and row2+3 in the same order based on row 2.

    So I want this:

    PHP Code:
    Row 1  house cherry tree chair

    Row 2  house cherry tree chair
    Row 3  34       32      33   56 
    I have 150 columns so it is not something I can do manually...

    Has anyone any idea? I hope I explained it clear enough.

    Thank you all,
    Bine

  2. #2
    Neophyte D_Walla's Avatar
    Join Date
    Aug 2020
    Posts
    1
    Articles
    0
    Excel Version
    Office 365

    Transpose the data....?

    I must confess that I don't quite understand what you're trying to do, or more importantly, how it is that those rows are ordered in that way (it's neither alphabetical nor numerical), but I wonder if what you might need to do is transpose the data - then organise it how you like, and transpose it back.
    Click image for larger version. 

Name:	tranpose.png 
Views:	12 
Size:	8.6 KB 
ID:	10627

  3. #3
    Seeker Bine's Avatar
    Join Date
    Dec 2020
    Posts
    9
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by D_Walla View Post
    I must confess that I don't quite understand what you're trying to do, or more importantly, how it is that those rows are ordered in that way (it's neither alphabetical nor numerical), but I wonder if what you might need to do is transpose the data - then organise it how you like, and transpose it back.
    Click image for larger version. 

Name:	tranpose.png 
Views:	12 
Size:	8.6 KB 
ID:	10627

    Hi, no unfortunately not. The point is that i want to order both rows in the same way (Not numerical, not alphabetical), just row 1 needs to have the same order as row 2.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,999
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Bine View Post
    just row 1 needs to have the same order as row 2.
    Copy row 2 to row 1?

Posting Permissions

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