switch column of table

If you have a table called A. And this table has three columns. How can you replace column three with column two?

[Paolo]

 A = [1 2 3; 2 3 4; 3 5 6]

A =

     1     2     3
     2     3     4
     3     5     6

A(:,3)=A(:,2)

A =

     1     2     2
     2     3     3
     3     5     5

Eliah, I have noticed you have asked a few questions, however have never selected an answer as accepted. This would be helpful for the community as it makes helpful solutions stand out, which could then help other people who are facing the similar issues.

[Walter Roberson]

The above will not work exactly as written for a table() object. However you can use

A{:,3} = A{:,2};

[Eliah Verbeemen]

I get the message Index exceeds matrix dimensions. Do you knwo why?

[Walter Roberson]

Are you sure that you are using a table() object and not a cell array or numeric array? And are you sure that your table object has three columns already?

[Eliah Verbeemen]

Finnaly there is a working code. Probably re you right and was I working with a cell array. I have changed a lot of things untill it worked. Trail and error.

[Walter Roberson]

Please do not close questions that have an Answer.

Answer 1

[Akira Agata]

If you have the latest version (R2018a), you can simply do it by movevars function, like:

yourTable = movevars(yourTable,2,'After',3);

[Eliah Verbeemen]

I have an old version 2016a