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

2 views (last 30 days)
Nimisha
Nimisha on 15 Nov 2018
Answered: Peter Perkins on 15 Nov 2018
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...

Sign in to answer this question.

Answers (2)

madhan ravi
madhan ravi on 15 Nov 2018
use readtable()
  1 Comment
Nimisha
Nimisha on 15 Nov 2018
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.!!

Sign in to comment.

Peter Perkins
Peter Perkins on 15 Nov 2018
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.

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!