The Manipulate Lists action is a general-purpose action for reading and writing from lists. It supports many list operations, each with their own set of fields.

#List

Specifies the list to manipulate.

#Operation

Selects an operation to perform on the list.

#Add Row

Adds a new row to the list by inserting a value into the first column. The placement of the row is specified with the Placement fields.

#Remove Row

Removes a row from the list. If a Destination Variable is specified, the value of the first column in the removed row is stored there.

#Sort Rows

Sorts the rows based on the value of the first column.

#Sort Columns in a Row

Sorts the columns in a particular row, from left to right.

#Shuffle Rows

Randomly shuffles the order of the rows in the list.

#Shuffle Columns in a Row

Randomly shuffles the order of the columns in a particular row.

#Remove Cell

Removes a cell from a row, optionally storing its value in a variable.

#Copy Cell to Variable

Copies the value of a given cell into a variable.

#Copy Variable/Value to Cell

Sets the value of a given cell to a number or variable reference.

#Set Variable to Number of Rows

Stores the number of rows in a given list to a variable.

#Set Variable to Number of Columns in Row

Stores the number of columns in a given cell to a variable.

#Duplicate List

Copies the contents of a list to another list. The contents of the destination list are replaced.

#Copy Row to List

Copies a single row from one list to another.

#Clear List

Erases all of the rows in the given list.

#Copy List into List

Copies the contents of one list and adds them to another list. The destination list’s existing rows are not removed.

#Move Row to List

Moves a row from one list to another, deleting it from the first and adding it to the second.

#Copy Value Only

On operations that read data from cells, this checkbox ensres that the copies occur “by value”. If checked, the destination list will contain only numbers, even if the source list had variable references. This option copies the value of variable references, rather than the reference itself.