How to Sort following table data in excel containing multiple column ?

I have table as below and i want to sort as expected output as below. How to perform using MATLAB. Table is inside Excel/csv format. ?

Column1 Column2 Column3 Column4

ABC DEF 12 DGMN

PQR MNO 17 DGSD

DEF JPG United DGFS

JPG PQR 21Hi DFPR

SQL STF STM DGBC

PQR YZW Hello90 DGSF

MNO ABC DQT DGCV

STF SQL A18B DGFD

I want to Match column1 data with Column2 data and want to add new 2 columns(5&6) with sorted data as below.

Column1 Column2 Column3 Column4 Column5 Column6

ABC DEF 12 DGMN DQT DGCV

PQR MNO 17 DGSD 21Hi DFPR

DEF JPG United DGFS 12 DGMN

JPG PQR 21Hi DFPR United DGFS

SQL STF STM DGBC A18B DGFD

PQR YZW Hello90 DGSF 21Hi DFPR

MNO ABC DQT DGCV 17 DGSD

STF SQL A18B DGFD STM DGBC

I know only to read excel as xlsread and scan data...

Answer 1

[madhan ravi]

use readtable()

[Nimisha]

I have completed reading operation using xlsread.

Readtable is similar. '

Next thing to do is Compare first column with second column, and if matches then sort rows as shown.!!

Answer 2

[Peter Perkins]

This sounds like a join, but for some reason you have everything in one table.

I'm guessing you can use ismember on the two leading table variables, and get the row numbers as the second output.