Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

How would you combine arrays, of unknown size, into one array? (without using VBA)

How would you combine arrays, of unknown size, into one array? For example, you want to combine data from two columns into one tidy column. The challenge is that the data hasn’t been entered yet, and you don’t know how many rows will be in each column.
0
tike55
Asked:
tike55
1 Solution
 
StephenJRCommented:
You probably have to set up a third array, loop through the others and add them to the third one. Post a workbook?
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now