Manuals/calci/PASTEROWS
PASTEROWS (A,B)
- and are the set of values.
and 
are the set of values.Description
- This function is used to paste the extra row to the given set of values.
- In , is the any set of values. 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.
,
Examples
1. PASTEROWS([[1,2,3],[4,5,6],[10,18,17],[3,65,-23],[-21,67,90]],[-2,-4,-10])
| 1 | 2 | 3 | -2 |
| 4 | 5 | 6 | -4 |
| 10 | 18 | 17 | -10 |
| 3 | 65 | -23 | 0 |
| -21 | 67 | 90 | 0 |
2. PASTEROWS([[3,8,10,14,17],[23,25,21,10],[17,14]],[2,6.3])
| 3 | 8 | 10 | 14 | 17 | 2 |
| 23 | 25 | 21 | 10 | 6.3 | |
| 17 | 14 | 0 |
Related Videos
See Also
References