View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Smith[_2_] Andy Smith[_2_] is offline
external usenet poster
 
Posts: 50
Default Combine data in columns from 2 tabs

It's two simple copy-and paste operations.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard and Poor''s, NYC



"Cong Nguyen" wrote:

Please show me how to combine data in columns from 2 different tabs:
TAB1
COL.A COL.B COL.C
RANK P/N S/N
1 A 27
28
2 B 12
5
8
3 C 43
55

TAB2
COL.A COL.B COL.C
RANK P/N S/N
1 E 67
9
11
2 F 20
7
3 G 1
66

Final data should look like:
COL.A COL.B COL.C
RANK P/N S/N
1 A 27
28
2 B 12
5
8
3 C 43
55
1 E 67
9
11
2 F 20
7
3 G 1
66

Thank you.


--
Cong Nguyen