Rearranging assigned data in a required order

Hi,

I want to read an excel file of two columns. Column A is assigned with values in Column B.

Ex:

Col A 1 2 3 4 5 6 7 8 9 10

Col B 10 8 5 25 31 12 29 1 21 44

How can I get the output of Column B reassigned to any specific order of Column A

Ex: o/p for the following order of

Col A 2 6 8 4 9 3 1 5 7 10

as

Col B 8 12 1 25 21 5 10 31 29 44

Thank you.

Answer 1

[Stephen23]

That is just basic indexing:

Bnew = B(A)

https://www.mathworks.com/help/matlab/math/matrix-indexing.html

Answer 2

[JAGAN MOHAN KUMMARI]

Thanks, Stephen!

Got it.

a=xlsread('values.xls');

b=a(:,2)

c=a(:,3) % col c is the required order from a

b([c]) % gives the answer

Thanks.

[Stephen23]

The square brackets are superfluous:

b(c) % gives the answer

https://www.mathworks.com/matlabcentral/answers/35676-why-not-use-square-brackets

[JAGAN MOHAN KUMMARI]

Got it. Thanks mate!

[JAGAN MOHAN KUMMARI]

Hi Stephen,

I am indexing values from an excel sheet. Rearranging values in Columns A to X in the order defined in Column B of another excel file. Total 62 rows x 24 columns.

US=xlsread('USDScoord.xlsx','Sheet1',''B:B');

for a=xlsread('US.xlsx','Sheet1','A:X')

d=a(US)

end

Getting the output as a single column as

d=....

d=....

How can I get the output in 62x24. Trying to define cells/zeros for 'd' but not getting successful.

Thanks.

[Stephen23]

I suspect that you want this:

idx = xlsread('USDScoord.xlsx','Sheet1',''B:B');
mat = xlsread('US.xlsx','Sheet1','A:X');
mat(idx,:)

[JAGAN MOHAN KUMMARI]

True. Got it. I need more learning. Getting familiar with things.

Thanks mate!

[Stephen23]

@JAGAN MOHAN KUMMARI: check out the link in my answer.