Entering edit mode
2.6 years ago
Bine
▴
60
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