How to combine 2 columns into 1 column

[maeyks]

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!

 

[sandy666]

try PowerQuery (Get&Transform) and Append feature

 

[maeyks]

That is very complex... thanks for the reply

try PowerQuery (Get&Transform) and Append feature

 

[sandy666]

Google is your friend

Power Query Append