824 questions
1
vote
1
answer
61
views
VBA Excel- Spell Check on Merged Cells
I have several merged cell ranges (unlocked) on a protected sheet that I want to spell check, respectively, based on the color index. Problem is 1) that it checks all these ranges and 2) after it is ...
0
votes
1
answer
162
views
How to merge two dates?
Problem Statement:
I have a single table in Google Sheets with two date fields: Sales Order Date and Dispatch Date.
I want to create a single line chart in Google Looker Studio that shows Sales Qty ...
0
votes
1
answer
31
views
Merge the 2 array based on id and prioritize the latest filtered on top
const menuFilteredProducts = getMenuWiseProduct(products);
const categoryFilteredProducts = getCategoryWiseProduct(products);
let mergedProducts = [];
const prioritizeCategory = true;
if (...
-1
votes
2
answers
76
views
Merge objects inside an array of objects with duplicates
I have "available" data and want to convert it into "desired".
I tried to merge all objects inside array using this but its not working coz as you can see for timestamp = 10 we ...
- 13
2
votes
4
answers
156
views
Why I could not simply read sheets and merge all the content in a single Variant?
Context: I'm trying, in VBA / Excel, to read the content of multiple large sheets (arround ~100k rows in total) and to store it in a Variant in order to work on the data in memory.
Why : I want to ...
- 45
0
votes
2
answers
174
views
How to combine multiple query formula results with the same number of columns vertically? [duplicate]
I have a spreadsheet with 31 Day level sheets and a few summary sheets being used for a daily sales report, using which I'm trying to create a legder. For this, I want columns A, B and C from each of ...
0
votes
2
answers
225
views
Merging sorted arrays with defined length in Python (good practices)
I have encountered interesting case during practicing writing Python algorithms on Leetcode.
The task: "You are given two integer arrays nums1 and nums2, sorted in non-decreasing order, and two ...
- 3
0
votes
2
answers
75
views
Why aren't the 0s being spliced out when merging a sorted array?
I'm working on this challenge:
https://leetcode.com/problems/merge-sorted-array/
This is my code:
/**
Do not return anything, modify nums1 in-place instead.
*/
function merge(nums1, m, nums2, n) {
...
- 529
0
votes
4
answers
56
views
Multidimention Array combine with one array in javascript with specific key
I have one array like below
[
{
"__typename": "ConfigurableProduct",
"uid": "MzY3",
"name": "AISLING BODYSUIT",
"crosssell_products&...
- 2,440
1
vote
6
answers
564
views
Combining two or more arrays into one array according to numeric keys without duplicates in subarrays
I have the following scenario made of arrays with numeric keys.
I need to have an array which stores all the values in the arrays grouped by numeric key and without duplicates.
I cannot make them ...
2
votes
1
answer
541
views
How to use INDIRECT (or alternative) in an Array into a Matrix
I want to merge multiple arrays that are in multiple sheets into a single matrix with the size of Max(Columns(arrays)) x Count(arrays).
See image bellow to better understand the inputs and expected ...
- 21
0
votes
1
answer
31
views
How I can select two elements to one list with linq
Firstly I need to create string array that include elements came from different properties of one object.
At the below code MyDatas is IEnumerable, prop1 and prop2 are string.
var array = myDatas....
- 25
0
votes
1
answer
115
views
Array merge from foreach loop in PHP
I'm making a website that uses foreach loop for the output. The output is a bunch of arrays, but it's not quite right. I used the foreach twice because it requires 2 arrays for the output. I got the ...
- 3
0
votes
0
answers
963
views
Combining Xarray datasets is too slow
I am working with satellite data which has measurements over different locations for different times. I am working with netcdf data in the form of xarray Datasets. I'd like a "union" of ...
- 126
0
votes
1
answer
3k
views
Merge duplicate cells - Google Sheets
The intended operation is to search column A for duplicate values (column is already sorted). Each duplicate value in A should be merged into 1 cell. Also, merge the same rows in B,C,D,E,F,G,H (take ...
1
vote
1
answer
88
views
Merge two multidimensional arrays using recursion, but not on full data set
I'm trying to add 2 array data to each other with array_merge(). It's just attached to the back. But lower levels are ignored.
Is there an alternative to array_merge() that will merge the user values ...
- 420
-1
votes
1
answer
433
views
Merge multiple WP_Query results into an array with no duplicates
I have a custom post type with its own custom template, and I want to display blog posts that are related to the custom post type title. However, I want to display a referenced post first, then search ...
- 25
1
vote
5
answers
87
views
Merge Objects in a array and increase count
[{name:"abc",value:5},{name:"abc",value:10},{name:"abc1",value:5},{name:"abc1",value:15}]
I want to merge it by name so that the new array will be
[{name:"...
- 780
1
vote
4
answers
926
views
I want to merge values of a nested Json object with javascript:
So How to merge values of a Json object like this:
{"zz0": "value 1","zz1": "value 2","zz2": "value 3"}
into this:
{"key":["...
- 393
1
vote
0
answers
155
views
DBT- Nested_Table Merge
I want to do a merge operation in DBT.
my target table is nested. I wrote the code in 2 steps.
In the 1st stage, I bring it to the level I want in my target table.
In part 2, I merge it. but since I ...
0
votes
1
answer
111
views
How to merge existing Google Sheet tabs copy a range of variable unknown length and append those values to a new sheet using Google Apps Script?
I'm a novice at programming, let alone Google AppsScript. Hopefully this is detailed enough for you to understand my issue and help me find a solution.
I am currently pulling data from an API and ...
- 21
1
vote
1
answer
97
views
How to best merge arrays?
I have 3 arrays. I need to add some values from array "data2" and "data3" to "array1".
I wrote a code example, but in my code, I missing all indexes that do not exist in ...
- 21
0
votes
0
answers
54
views
Merge results of PHP functions as one JSON object
I have three functions, live_event() - the main function, archived_video() - runs inside live_event() if conditions fail and additional_videos() which should be run in all cases and its results ...
- 5,563
0
votes
1
answer
152
views
Is there a way to merge two nested array based on common key [closed]
This are the two array that needs merging based on common id, the nested array should also be merged
First Array
const arr1 = [
{ id: 1, name: "sai", accounts: ["a"] },
{ ...
- 13
-1
votes
3
answers
204
views
Merge arrays with Sum specific value keys
If someone has already done it, the idea is to merge different arrays into one and also merge the values sum of price, qty only for the identical keys.
In my example I only put two arrays to be merged ...
- 744