Excel - Combine multiple columns into one column

Question

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.

Also what about if ROW1 has headers from January to December, and the length of the columns are different and needs to be combine into one big 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.

Answer 1

In Excel, how can I concatenate (combine) many columns into one field?
In column D, use the CONCATENATE function: =CONCATENATE (A1,B1,C1).
Select Insert, Function from the menu bar.
Fill in the text1 field with A1, the text2 field with B1, and the text3 field with C1.
Click the OK button.
Copy and paste as many records as you require.