merge array

  1. M

    Filter using mutiple sheets to create an array?

    I am looking to colate a list of values which appear on multiple tabs in a work book. Sheet 1 and 2 below have varying data but not all in the same columns. ABC1NumbersLettersColours2123abcblue3456defred4789ghiyellow...
  2. P

    Combining repeated rows from 2 sheets' data based on a key

    I am having 2 sheets in excel and I am trying to combine the data such that for every record in Sheet1, I get records from Sheet2 based on the common key. Below is the sample data to clarify: I have SHEET 1 and SHEET 2 Data and I want to generate something like SHEET 3. Can you please suggest...
  3. P

    Combine rows into a single cell based on word match

    I am facing a difficulty in merging the row data into a single cell. based on certain word match in column B. I am looking for a VBA or excel custom function. If the word match in column B (it should not compare word with is part of another word), it should merge the rows. However,if any...
  4. A

    Consolidation: 3 Separate Lists Contacts That Have Partial Match but no Unique ID to merge rows.

    Hi Folks, So today I was thrown a curve ball on a project I'm working on. I Have 3 sheets of contacts from 3 different vendors which are all different sizes. These Sheets have very little overlap besides a few columns..."FULL NAME", "COMPANY NAME","ADDRESS LINE 1" and maybe a few other columns...
  5. J

    merging specific column of 3 array in a new array

    To all The merging of array has been addressed in a few posts but before I write my own (copy someonelse!) code to loop through the arrayI tought I asked here 1st I have 3 arrays of the same length (n row, 2 column): xarray, yarray, zarray and the data are numbers something like 0.,0...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top