Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Combine data in columns from 2 tabs

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

  #2   Report Post  
Posted to microsoft.public.excel.misc
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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Combine data in columns from 2 tabs

It won't make any difference using formulas, if anything it is slower. If
you have duplicates

http://www.cpearson.com/excel/Duplicates.aspx

use the method above and delete the duplicates or use code


http://www.rondebruin.nl/tips.htm


look at the merge examples



--


Regards,


Peo Sjoblom




"Cong Nguyen" wrote in message
...
Andy,
Thanks for your response. But, my worksheet has too many of these and I
need
a formula.


--
Cong Nguyen



"Andy Smith" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I combine multiple columns of data into 1 column? Frank New Users to Excel 1 January 17th 07 08:37 PM
trying to combine 2 columns of data to create one x axis in graph ChristinaA Charts and Charting in Excel 2 September 18th 06 02:31 PM
Combine the data in 2 columns of 20 rows into one column of 40 row Tom Excel Discussion (Misc queries) 6 May 3rd 06 09:27 AM
How to combine data from two columns into one column? dcnguyen Excel Worksheet Functions 3 January 9th 06 12:40 AM
how can i combine 2 columns in excel into 1 without losing data? sturville Excel Discussion (Misc queries) 4 May 10th 05 04:11 PM


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"