Difference between revisions of "Manuals/calci/PASTEROWS"

Revision as of 12:46, 13 April 2018

PASTEROWS (A,B)

This function is used to paste the extra row to the given set of values.
In $PASTEROWS(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 side of the array value of A.
So number of columns will be increased and number of rows remaining same for the array A.
Suppose the entries of array B is more than the row value Array A then the additional value will be displayed on down of array A also the row number will be increased.

1. PASTEROWS([[1,2,3],[4,5,6],[10,18,17],[3,65,-23],[-21,67,90]],[-2,-4,-10])

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

@@ Line 11: / Line 11: @@
 ==Examples==
+. PASTEROWS([[1,2,3],[4,5,6],[10,18,17],[3,65,-23],[-21,67,90]],[-2,-4,-10])
+{| class="wikitable"
+|-
+| 1 || 2 || 3 || -2
+|-
+| 4 || 5 || 6 || -4
+|-
+| 10 || 18 || 17 || -10
+|-
+| 3 || 65 || -23 || 0
+|-
+| -21 || 67 || 90 || 0
+|}
+. PASTEROWS([[3,8,10,14,17],[23,25,21,10],[17,14]],[2,6.3])
+{| class="wikitable"
+|-
+| 3 || 8 || 10 || 14 || 17 || 2
+|-
+| 23 || 25 || 21 || 10 || 6.3
+|-
+| 17 || 14 || 0
+|}
 ==See Also==