Written by Arranges the specified row or column of cells into multiple rows based on a designated number of elements, resulting in a newly structured array.
Transforms a specified row or column of cells into a new array by organizing them into columns after a given number of elements.
Combines ranges vertically and sequentially to create a larger array.
Analyzes incomplete data pertaining to a linear trend, applies the least squares method to determine an optimal linear fit, and forecasts additional values accordingly.
Switches the arrangement of rows and columns in a specified array or cell range.
Converts a set of data or cells into a single horizontal row.
Converts a range of cells or an array into a single-column format.
Determines the total of squared differences from two sets of values.
Computes the sum of the squared values from two specified arrays.
Determines the total of the squared differences between corresponding elements from two arrays.