+ Reply to Thread
Results 1 to 5 of 5

Merging Two Excel Files with Different and Identical Data

  1. #1
    Registered User
    Join Date
    01-03-2020
    Location
    USA
    MS-Off Ver
    Excel for Mac 16.32
    Posts
    3

    Question Merging Two Excel Files with Different and Identical Data

    Hello,


    I have two excel files on my Mac. Both contain information regarding real estate properties. One file is new and the other is from 2018. The problem I have is that the older file contains data in columns that the new file doesn't have data for (Columns K through R) and I would like to add to the new file. The new file contains certain rows of data that the old file doesn't have. The old file contains some columns the new file doesn't contain. I've attached a sample excel file to explain the situation, as well as screenshots of the excel file. The real files contain around 7,000 rows of text data. I can't share the actual file since it contains confidential information. The sample file contains identical rows and columns of the real files, with sample data inserted.


    How can I add the rows of new data from the new file with the columns of text from the old file that are blank in the new file? Is there a way to merge both files together without losing data or mismatching rows and columns? Rows of data on the old file that aren't found on the new file need to be moved to the new file while still updating the rows of data still found in both files.


    Columns A through E contain updated data in the new file, along with new rows not found on the old file. Columns F through I are the same in the new file, with the exception of rows that were removed in the new file or didn't exist in the old file. Columns J through R need to have the same data in rows that existed in the old file, while they will be blank for rows that didn't exist in the old file. Columns S through W need to have updated data regardless of whether it was on the old file or not. My biggest concern is ensuring the individual rows of data stay with the correct property number (seen in Column A) when merging the data together.

    I have I have Excel for Mac 16.32 on my MacBook Pro (15-inch, 2016).


    I'd appreciate any advice.


    Thank you!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by rv4life; 01-03-2020 at 02:55 AM. Reason: Forgot to attach files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: Merging Two Excel Files with Different and Identical Data

    Welcome to the forum.

    Thread moved to the Mac section. It would be helpful, please, to indicate the version number of Excel for Mac that you have in your profile.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    01-03-2020
    Location
    USA
    MS-Off Ver
    Excel for Mac 16.32
    Posts
    3

    Re: Merging Two Excel Files with Different and Identical Data

    Will do. Thank you!

  4. #4
    Registered User
    Join Date
    01-03-2020
    Location
    USA
    MS-Off Ver
    Excel for Mac 16.32
    Posts
    3

    Re: Merging Two Excel Files with Different and Identical Data

    I have Excel for Mac 16.32 on my MacBook Pro (15-inch, 2016). I've added this to my signature.
    Excel for Mac 16.32
    MacBook Pro (15-inch, 2016)

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: Merging Two Excel Files with Different and Identical Data

    Adding it to your profile was enough, but thanks. Unfortunately you don't have PowerQuery in the Mac, which would have probably made this easy. I suspect you'll need a VBA solution.

+ 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. [SOLVED] Merging a lot of Excel files together
    By peterandrewsuk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 12:47 PM
  2. Merging two Excel files
    By oceanmd in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-17-2008, 12:05 PM
  3. Merging Excel Files
    By Xaivor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2008, 09:53 PM
  4. Merging Excel Files
    By Lupe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2006, 09:30 AM
  5. [SOLVED] Merging Different excel files into one
    By Neill in forum Excel General
    Replies: 0
    Last Post: 10-27-2005, 05:05 PM
  6. [SOLVED] merging my excel files
    By Donna YaWanna in forum Excel General
    Replies: 1
    Last Post: 06-13-2005, 08:05 PM
  7. merging excel files
    By Etringale in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 01:23 PM

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