+ Reply to Thread
Results 1 to 4 of 4

combing 2 tables into 1

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    combing 2 tables into 1

    Hello everyone

    I have 2 tables that I am trying to compare.
    Table 1
    ____ A B C D
    Row1 3 4 2 4
    Row2 1 5 4 3

    and Table 2
    ____ A B C D
    Row1 6 4 7 2
    Row2 2 4 5 1

    Does anyone know the code to quickly put them into a table that looks like this......
    ____A B C D
    Row1 3 4 2 4
    Row1 6 4 7 2

    Row2 1 5 4 3
    Row2 2 4 5 1

    Ta

    Kevin

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: combing 2 tables into 1

    Why not copy/paste?

    How many rows are there?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: combing 2 tables into 1

    Hi

    There are 25 rows in each table. I cannot get excel to extrapolate down correctly, it keeps missing out rows.

    I could copy and paste but with 50 rows in total, I hoped to find a more efficient way to do it.

    Kevin

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: combing 2 tables into 1

    How does " it keep missing out rows?" Sorry I cant help without a sample workbook as it seems your problem and solution are not well defined in text (and text is not as easy to digest as a workbook).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Inventory files combing
    By robertphtx in forum Excel General
    Replies: 6
    Last Post: 12-19-2012, 03:01 PM
  2. Excel 2007 : Combing formulas
    By ccampbell14 in forum Excel General
    Replies: 6
    Last Post: 07-12-2012, 02:15 PM
  3. combing dates and times
    By davittp in forum Excel General
    Replies: 2
    Last Post: 09-03-2007, 04:49 AM
  4. Combing Fields in a PivotTable???
    By ddawg09 in forum Excel General
    Replies: 2
    Last Post: 02-06-2006, 10:47 PM
  5. combing cells
    By Kelly E. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1