arraysgoogle-sheets-formulasequenceflattenamortization
Google Sheets - sequence function using array
I have a table that contains a column with Initial Year and another with the number of amortisation years. I'm trying to generate a new table that duplicates the rows where amortisation years is >1 and recalcs the Year for each duplication.
I've drafted an example and the incomplete solution I got to so far:
I'd ideally like to solve it using formulas (instead of a script). Breaking my head here, so really appreciate your help!
Solution
use:
=ARRAYFORMULA(QUERY(SPLIT(FLATTEN(A4:A9&"×"&B4:B9&"×"&IF(
SEQUENCE(1, MAX(D4:D9), 0)<D4:D9, C4:C9+
SEQUENCE(1, MAX(D4:D9), 0), )&"×"&E4:E9), "×"),
"where Col4 is not null", ))
- How to recursively merge two multidimensional arrays
- Why isn't array_merge() merging arrays by reference?
- Ignoring posts in wordpress already used in a loop
- Merge two flat arrays with the same count to form an array of associative arrays
- Array value sum by key value php
- Sum the values of a column in a 2d array
- Group values in an array of single-element arrays by second level key and sum values within each group
- Store and read hash and array in files in Perl
- Merge a flat associative array into another associative array
- Array of data showing in console but not in HTML after passing it through dialog in Angular project
- Sizeof vs array size
- How to merge two associative multidimensional arrays
- Merge two multidimensional arrays related by shared subarray column values
- Replace an array's values with the values from a lookup array
- Print grouped data as a single array
- Merge and sum data from two associative multidimensional arrays
- Sorting an array before inserting to database
- Array Intersection - only once
- Sort values within each row of a 2d array
- Group 2d array data by one column and then sort by another column
- Append data from one subarray to another subarray
- Sort an array according to another array
- Move an element by key before another element by key in the context of an associative array
- How do I desctructively iterate over an array of strings in rust?
- How to generate a random number array and sorting this array using php?
- Ajax Parse Error when returning array from PHP
- PHP MYSQL Array and sort
- Sort a 2D array by multiple columns
- Short circuit Array.forEach like calling break
- Passing a NumPy 3d array to a C function with a triple pointer as an argument