+ Reply to Thread
Results 1 to 9 of 9

Merge data from two datatapes

  1. #1
    Registered User
    Join Date
    08-13-2017
    Location
    Copenhagen
    MS-Off Ver
    10
    Posts
    14

    Merge data from two datatapes

    Hi all,

    I am struggling to merge data from two different data tapes.

    Please see attached. Anybody with a clever suggestion on how to do this?

    Help1.JPG

    Thank you in advance.

    Kind Regards
    Magnus
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,692

    Re: Merge data from two datatapes

    Is this what you wish your solution to look like?

    Excel 2016 (Windows) 32 bit
    P
    Q
    R
    S
    5
    Date Company Dividend Uniqe code
    6
    1/1/2020
    Company A
    10
    999
    7
    1/1/2019
    Company C
    9
    997
    8
    1/1/2021
    Company B
    11
    998
    9
    1/1/2022
    Company D
    12
    996
    Sheet: Sheet1

  3. #3
    Registered User
    Join Date
    08-13-2017
    Location
    Copenhagen
    MS-Off Ver
    10
    Posts
    14

    Re: Merge data from two datatapes

    Hi Alansidman,

    Yes! Thats exactly right.

    Would you mind sharing your knowledge?

    Kind Regards
    Magnus

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,692

    Re: Merge data from two datatapes

    this is the approach I would take to do this:

    https://www.youtube.com/watch?v=HcfKOusOJhA

  5. #5
    Registered User
    Join Date
    08-13-2017
    Location
    Copenhagen
    MS-Off Ver
    10
    Posts
    14

    Re: Merge data from two datatapes

    Thanks for the link!

    But as I am looking to do this in Google Sheets, Im not quite sure this will work.

    Do you agree or is Power Query available in Google Sheets as well?

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,692

    Re: Merge data from two datatapes

    Power Query is not an option in Google Sheets. Since you did not mention this in your original post, I am moving this to the applicable sub forum.

  7. #7
    Registered User
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    Office 365
    Posts
    94

    Re: Merge data from two datatapes

    Hi Magnus415

    Put the following formula in cell J6 of your GSheet: =QUERY({P6:S;U6:X7},"Select * where Col1 is not null")

    Let me know if this is what you are after.

  8. #8
    Registered User
    Join Date
    08-13-2017
    Location
    Copenhagen
    MS-Off Ver
    10
    Posts
    14

    Re: Merge data from two datatapes

    Hi Flyboy,

    Wauw, thats a nice one! Thanks for the help!

    Kind Regards
    Magnus

  9. #9
    Registered User
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    Office 365
    Posts
    94

    Re: Merge data from two datatapes

    Glad to help. Thanks for the feedback.

+ 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] Split merge doc and save in any of the merge field data
    By bmbalamurali in forum Word Formatting & General
    Replies: 5
    Last Post: 03-23-2018, 09:18 PM
  2. Replies: 2
    Last Post: 04-30-2017, 08:28 PM
  3. Sorting data between un-merge and merge
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2015, 04:28 PM
  4. [SOLVED] Mail Merge: The merge provides data from the previous record
    By bellevue in forum Excel General
    Replies: 3
    Last Post: 10-23-2012, 07:44 AM
  5. Mail Merge or just Merge Spreadsheet Data
    By Mooch in forum Excel General
    Replies: 3
    Last Post: 12-07-2010, 04:56 PM
  6. Replies: 0
    Last Post: 04-21-2006, 03:40 PM
  7. [SOLVED] how do i get my mail merge to update the data source at each merge
    By Steel_Monkey in forum Excel General
    Replies: 0
    Last Post: 11-30-2005, 04:45 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