Difference between revisions of "Manuals/calci/PASTECOLUMNS"

Latest revision as of 13:40, 18 March 2019

PASTECOLUMNS (A,B)

This function is used to paste the extra column to the given set of values.
In $PASTECOLUMNS(A,B)$ , $A$ is the any set of values. $B$ is the set of values to be pasted with the array value A.
The array of A value displayed as it is and the array of B value displayed by one by one down to the array value of A.
So number of rows will be increased and number of column remaining same for the array A.
Also the additional values will be pasted on the first column of array A.

1. PASTECOLUMNS([[1,2,3],[4,5,6],[10,18,17]],[-2,-4,-10])

2. PASTECOLUMNS([[3,8,10,14,17],[23,25,21,10]],[2,6.3])

@@ Line 10: / Line 10: @@
 ==Examples==
+. PASTECOLUMNS([[1,2,3],[4,5,6],[10,18,17]],[-2,-4,-10])
+{| class="wikitable"
+|-
+| 1 || 2 || 3
+|-
+| 4 || 5 || 6
+|-
+| 10 || 18 || 17
+|-
+| -2
+|-
+| -4
+|-
+| -10
+|}
+. PASTECOLUMNS([[3,8,10,14,17],[23,25,21,10]],[2,6.3])
+{| class="wikitable"
+|-
+| 3 || 8 || 10 || 14 || 17
+|-
+| 23 || 25 || 21 || 10
+|-
+| 2
+|-
+| 6.3
+|}
+==Related Videos==
+{{#ev:youtube|v=M2B8pSwwMMo|280|center|Columns}}
 ==See Also==
-*[[Manuals/calci/COLUMN| COLUMN]]
+*[[Manuals/calci/PASTEROWS| PASTEROWS]]
 *[[Manuals/calci/COLUMNS  | COLUMNS ]]
 *[[Manuals/calci/ROW  | ROW]]
 ==References==