Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine data in columns from 2 tabs
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
trying to combine 2 columns of data to create one x axis in graph | Charts and Charting in Excel | |||
Combine the data in 2 columns of 20 rows into one column of 40 row | Excel Discussion (Misc queries) | |||
How to combine data from two columns into one column? | Excel Worksheet Functions | |||
how can i combine 2 columns in excel into 1 without losing data? | Excel Discussion (Misc queries) |