+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Merging Individual and Group level data - Copying multiple columns of matched data?

  1. #1
    Registered User
    Join Date
    04-08-2012
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    18

    Merging Individual and Group level data - Copying multiple columns of matched data?

    Hi all,

    First time posting so thanks for your help in advance! I am trying to merge individual level data with group level data. For example, I have a team ID on one sheet with about 20 columns of data and multiple individuals that are part of that team on another sheet. The only way to match the groups to the individuals is with the group ID.

    In other words, I am trying to match values in two different columns, then copy the value in column B and about 20 columns worth of data to the right of column B next to the matched value in column A. But here's the catch, there are multiple identical values in column A (representing the different individuals within the team) and I want to match and copy the same 20 columns worth of data to each of the matched values. It's not simply the case that I want to copy one cell or column worth of data when I find a matched value, I need to copy multiple columns worth of data for each matched value and there will be multiple matched values.

    So here is a simple example of what my data look like. Columns A:D are on one sheet and columns G:J are on another sheet. I put "XX" to indicate important data that I will need to keep grouped:


    A1:XX B1:XX C1:XX D1:SHAL G1:SHAL H1:XX I:XX J1:XX
    A2:XX B2:XX C2:XX D2:SHAL G2:SING H2:XX I:XX J2:XX
    A3:XX B3:XX C3:XX D3:SHAL G3:SITA H3:XX I:XX J3:XX
    A4:XX B4:XX C4:XX D4:SING
    A5:XX B5:XX C5:XX D5:SING
    A6:XX B6:XX C6:XX D6:SITA
    A7:XX B7:XX C7:XX D7:SITA

    In this example, I need to match G1 to all the matched values in column D and then copy G1:J1 next to the matched values in column D.

    Does that make sense? I really appreciate any advice you can provide. Is there a way to do this using basic excel only? I do not have experience with VB or macros.

    Thanks!

  2. #2
    Registered User
    Join Date
    04-08-2012
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Merging Individual and Group level data - Copying multiple columns of matched data?

    Just wanted to bump this to the top of the thread...can anyone help me with this?

    Thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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