Difference between revisions of "Manuals/calci/PASTECOLUMNS"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
==Examples== | ==Examples== | ||
| + | 1. 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 | ||
| + | |} | ||
| + | 2. 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 | ||
| + | |} | ||
==See Also== | ==See Also== | ||
Revision as of 12:40, 13 April 2018
PASTECOLUMNS (A,B)
- and are the set of values.
and 
are the set of values.Description
- This function is used to paste the extra column 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 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.
,Examples
1. PASTECOLUMNS([[1,2,3],[4,5,6],[10,18,17]],[-2,-4,-10])
| 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])
| 3 | 8 | 10 | 14 | 17 |
| 23 | 25 | 21 | 10 | |
| 2 | ||||
| 6.3 |
See Also
References