data merging

  1. T

    Merge Data from Two Tables Based on a Lookup Value

    Hi, I have two tables that have one column with similar values. I need to create a table that would merge the data from both the tables based on the matched values. I have prepared a Sample Sheet. https://www.dropbox.com/s/wq1nin6x6v0gfxg/Sample%20for%20Help.xlsx?dl=0 Concatenating the...
  2. S

    Merging data - starting row x instead of first row

    hi I have X sheets which contain data in a fixed range R5C1:R13C46. I am trying to create a master tab with the data of each tab. I plan to import the title line at the end only I wrote the code below but it always start pasting in the Master tab from row 44. I am not able to figure out why...
  3. J

    Data merge from excel to word

    Hey, I am currently in the process of automating audits at work. Currently we are working off an interface in excel and writing the reports out manually in excel. What I am after doing is installing a button that can merge certain cells in to marked places in a word template. For example...
  4. M

    Please help on data Cleaning, lookups and merging

    Hi All, I have been working with large excel files ranging from 500,000 to 800,000 plus rows of data. Cleaning, matching and merging data is time consuming. I am wondering if you have an good approach of dealing with large data files? Any good data cleaning and matching tools to recommend...
  5. B

    Multiple occurance data lookup

    Hello, So i have an issue that is quite complex. The status quo is as follows: My customer will send me raw data as follows (call it table A): <TABLE style="WIDTH: 279pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=372 border=0><COLGROUP><COL style="WIDTH: 113pt...
  6. 2

    Merging Rows of Data. Not straighforward.

    Hi I hope someone out there can help me. I'm trying to merge rows in a spreadsheet that contains about 700-100 rows and 8 columns of data. There is nothing to identify the groups except its vertical linear position so any merging of data that occurs cannot affect adjacent cells. The data is...

Watch MrExcel Video

This Week's Hot Topics

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
Top