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!
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!