Order to rows in the same way

Bine

New member
Joined
Dec 3, 2020
Messages
12
Reaction score
0
Points
1
Excel Version(s)
Excel 2016
Dear all,

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

Example:


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:

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
 
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.
tranpose.png
 
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.
View attachment 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.
 
Back
Top