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...

Some videos you may like

This Week's Hot Topics

Top