Difference between revisions of "Manuals/calci/PASTECOLUMNS"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
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
 +
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=M2B8pSwwMMo|280|center|Columns}}
  
 
==See Also==
 
==See Also==

Latest revision as of 14:40, 18 March 2019

PASTECOLUMNS (A,B)


  • 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

Related Videos

Columns

See Also

References