Forum Discussion
Adding a column with fixed value in matrix
Hi, I am creating a P&L in matrix and along with the amount column i want to add a percentage column which divides row value with total revenue. therefore I want to calculate a measure which sho...
Suppose you have:
>> A=reshape(1:16,4,4)
A =
1 5 9 13
2 6 10 14
3 7 11 15
4 8 12 16
>> B=(17:20)'
B =
17
18
19
20
Then you could obtain the desired matrix C by:
>> C = [A(:,1:2) B A(:,3:4)]
C =
1 5 17 9 13
2 6 18 10 14
3 7 19 11 15
4 8 20 12 16
So you take the first two columns of A concatenate the column B and then concatenate the last two columns of A.
You can generalize this a bit into:
>> D = [A(:,1:N) B A(:,N+1:end)]
Where N then stands for "insert B after the Nth column".