How to combine 2 columns into 1 column

maeyks

Board Regular
Joined
Aug 20, 2010
Messages
122
Good afternoon.

Here is the scenario, I have 2 sheets, sheets a and b. i have sheet c. what i would like to do is to combine sheet a's column b values and sheet b's column c values together in sheet c column A

the hard part is how to join them 1 one column, one whole value right after the other

for example, sheet a column b has b2:b1000 while sheet b column b has b2:b5000; so its like the rows 2 to 1001 will be from sheet a to be followed at 1002 to 5003 from sheet b

but both columns from both sheets has the tendecy to increase in number

thanks!
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,114
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top