Excel - Combine multiple columns into one column
Hey everyone. I'm new to excel and VBA and I'm stuck at this problem.

I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one big column. I do not care if there are duplicate entries, however I want it to skip row 1 of each column. 


ROW1| 1   2   3

ROW2| A   D   G

ROW3| B   E   H

ROW4| C   F   I

should combine into 

A

B

C

D

E

F

G

H

I


The first row of each column needs to be skipped.


Excel - Combine multiple columns into one column
===

Hey everyone. I'm new to excel and VBA and I'm stuck at this problem.

I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one big column. I do not care if there are duplicate entries, however I want it to skip row 1 of each column. 


ROW1| 1   2   3

ROW2| A   D   G

ROW3| B   E   H

ROW4| C   F   I

should combine into 

A

B

C

D

E

F

G

H

I


The first row of each column needs to be skipped.

