Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

232
Views
Agregar una sola matriz de una matriz en una matriz de una matriz multidimensional en Excel Scripts/Javascript

buscando agregar una sola matriz en una matriz multidimensional o una matriz de matrices.

por ejemplo:

 Data = [["A","B","C","D"]]; NewData =[[1,2,3,4],[5,6,7,8],[9,10,11,12]]; CombinedData = []; for(i=0; i< NewData.length; i++){ CombinedData.push(...Data,NewData[i]); }

Sin embargo, lo anterior da como resultado esto: "CombinedData =[["A","B","C","D"],[1,2,3,4],["A","B","C ","D"],[5,6,7,8],["A","B","C","D"],[9,10,11,12],["A", "B","C","D"]...]"

Donde lo que busco es esto: "CombinedData =[["A","B","C","D",1,2,3,4],["A","B","C ","D",5,6,7,8],["A","B","C","D",9,10,11,12],]"

Esto está en ExcelScripts o scripts de Office, que sé que es bastante nuevo, pero solo busca algún tipo de dirección.

about 4 years ago · Santiago Trujillo
1 answers
Answer question

0

Debe distribuir ambas matrices y envolverlas entre paréntesis para crear una nueva matriz.

 const Data = ["A","B","C","D"]; const NewData =[[1,2,3,4],[5,6,7,8],[9,10,11,12]]; var CombinedData = []; for(i=0; i< NewData.length; i++){ CombinedData.push([...Data,...NewData[i]]); } console.log(CombinedData);

Además, podría usar el mapa en lugar del bucle for:

 const Data = ["A","B","C","D"]; const NewData =[[1,2,3,4],[5,6,7,8],[9,10,11,12]]; var CombinedData = NewData.map(x=>[...Data, ...x]); console.log(CombinedData);

about 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!