Share via

How to merge multiple arrays of data into one

Anonymous
2022-12-29T10:32:32+00:00

Hi there. Hoping someone knows a way of doing this. I have multiple arrays of data (about 35 columns by 10,000 rows each) and I would like to overlay the arrays so that the data from each one is combined into one array. For instance, if I have:

1 3 2 4

5 7 and 6 8

I would like to merge them such that I have an array that reads:

1;2 3;4

5;6 7;8

where 1;2 , 3;4 , 5;6 , and 7;8 each occupy a single cell. Any advice on how to achieve this would be very appreciated. Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2022-12-29T10:59:28+00:00

    A4: =A1&";"&D1

    drag down and to the right.

    0 comments
  2. riny 20,530 Reputation points Volunteer Moderator
    2022-12-29T11:14:31+00:00

    Or when you are Excel version supports LAMBDA and its helper functions, try this:

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more