Order to rows in the same way

Order to rows in the same way

0

Dear all,

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

Example:

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:

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


excel

• 38 views

Read more here: Source link