Category "transpose"

How to concatenate ranges using formulas, even when there are blanks to be considered on Google Sheets?

The problem consists of concatenating multiple horizontal ranges containing product1, brand1, price1, product2, brand2, price2 and so on, even when the cells ar

Merge column values from two arrays to form an indexed array of associative arrays

I have two arrays: $a = ['0' => 1, '1' => 2, '2' => 3] $b = ['0' => 4, '1' => 5, '2' => 6] I want to create a new array like this: [ ['

Transpose multidimensional array and join values with commas

How to group by comma of every value as per same key? I need to re-orientate the array so that rows become columns and the new rows need to be joined together

Downfill incremetation skip 2 columns

I'm trying do create a master sheet for work, as for nom we work in the middle age, copying some data to up to 4 differents documents and I want that to change

GBQ Transpose Dynamically without Execute Immediate

Hi All trying to figure out a way to transpose data in columns dynamically. In the data the distinct number of Traits will increase/decrease. I know I can hardc

How to average columns of data from multiple, flat arrays?

Let's say I have 4 arrays with the same amount of values in each: $array1 = array(0, 7, 5, 0); $array2 = array(2, 6, 10, 0); $array3 = array(4, 8, 15, 10); $arr

Transpose and flatten multiple rows of array data [duplicate]

Is there a native PHP function to zip merge two arrays? Look at the following example: $a = array("a","b","c"); $b = array("d","e","f"); $c

Sum column values from multiple arrays

I have an arrays with dynamic name. My array could be more than 3, depends and array variable should be unique $loopThrice = 3; $getSum = 0; $total = array();

PHP array, move keys and values to new array, but mix it up

so I need to convert a PHP array i'm getting from a form post, so that I can use it more usefully in a db. Array ( [first_name] => Array ( [0]

Sum array values of a column within each column of an array with 3 levels

I'm trying to use array_sum() on columns within columns of a multidimensional array. For eg: I have an array that looks like this: $array = [ [['value' =>

Chunk and transpose a flat array into rows with a specific number of columns

An array of values are provided in the order they should appear in columns. For example, the second value in the array should be displayed on a webpage beneath

Switch values and headers

I have a google sheet with a table card1 | card2 | card3 | card4 | card5 | card6 | card7 ------+-------+-------+-------+-------+-------+------ set3 | set1 |

Insert database rows from columns of data from associative array of indexed arrays

I have an array called $works which looks like this: [ 'type' => [1, 5], 'description' => [2, 6], 'hours' => [3, 7], 'amount' => [4,

Explain how this array transposing and flattening function works

Here this function in PHP that allows to merge any N amount of different length arrays in a fashion that output array will be in next order: Array1[0],Array2[0]

How to switch columns rows in a pandas dataframe

I have the following dataframe: 0 1 0 enrichment_site value 1 last_updated value 2

Transpose csv file data [duplicate]

I need help to assign keys to an array in PHP. My code is: //First I make an array of a csv file $file="C:\path-to-csv\file.csv"; $csv= file

SQL Transpose Rows to undefined number of columns

I have a table containing graduate ids, degree titles and graduation years. The table can contain any number of rows for each graduate. I would like to create

Transpose and flatten two-dimensional indexed array where rows may not be of equal length

I would like to take an array like this and combine it into 1 single array. array (size=2) 0 => array (size=10) 0 => string '1'