help merging to tables into one

**ittop** · 2012-01-13, 06:33 PM

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

**Ken Puls** · 2012-01-20, 06:47 PM

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.)

**ittop** · 2012-01-20, 08:57 PM

here is a sample i have to combine sheet 1 and 2

**ittop** · 2012-01-20, 08:59 PM

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

**askrocks** · 2012-01-20, 10:02 PM

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 ?

**ittop** · 2012-01-20, 10:37 PM

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

**Ken Puls** · 2012-01-21, 05:45 AM

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?

**ittop** · 2012-01-21, 03:05 PM

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

**Ken Puls** · 2012-01-23, 03:41 AM

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?