Arranging Data based on relationship different columns

Hi, I have two set of data that I am trying to "merge". To "merge" them, I have to take into consideration, two columns in one of the set, and one column in the other set. Let's say in Data set 1, I have column A and column C. In the second set of data, I have column B. I want to arrange the data into one so that the numbers in each of the row of column B is less or equal to the numbers in each row of column A, and more than the numbers in each row of column C: ColumnA< ColumnB< ColumnC.

I was wondering if there was a function in Matlab that would help me with that. It is kind of complicated.

Thank you.

Answer 1

[dpb]

X=sort([A B C],2,'ascend');