Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: help merging to tables into one

  1. #1

    help merging to tables into one



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i have a set of data
    now i want excel to look up value 12345 from table 1 search table 2
    and return with entire column
    thus now making a table with 5 cloumns
    and matched correspondingly how do i do that1 want
    12345 1/2/2011 4/2/2011
    12567 2/25/2011 3/20/2011
    1257 3/20/2011 4/20/2011

    12345 1/23/2011
    12567 2/25/2011
    3456 3/5/2011

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    Hi there,

    Sorry for the late reply, and not sure if you still need help with this. if you do, it might be helpful to upload a sample workbook for us. (Just click Go Advanced, and you can do so.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    here is a sample i have to combine sheet 1 and 2
    Attached Files Attached Files

  4. #4
    what ever method i use it looks up the first column of data and ignores the rest

  5. #5
    I need a clarification on this, as per your sheet, you want to lookup the values in Column A which would return the values in the entire Corresponding row is it ?? Can you please describe this better ?

  6. #6
    Yes i want to merge all values corresponding to A into single column

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    I'm still not quite following this either.

    Can you product a sheet that shows us what the expected output will look like from what you've already given us?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #8
    sure this is the way i want the result
    i have a pivot table of sheet 2 can i merge it with normal table of sheet 1
    or can i merge 2 pivot table
    Attached Files Attached Files

  9. #9
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    Sorry, so in the example file, you have sheet 1 and sheet 2... you want to copy all the data from sheet 2 and append it to the data table in sheet 1, is that correct?

    Sheet 2's data is in a pivot table... is sheet 1's data as well, or is it just a range of data, and not a formal table?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  10. #10
    yes ur right sheet 2 is a pivot table sheet 1 is a normal table

Page 1 of 2 1 2 LastLast

Posting Permissions

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