Multiple columns into a single column

Hello,

I am using excel 2013 and I want to convert a range of data with variable no. of columns and 24 rows to a single column (columns stacked one below the other) having missing data in between. how can that be done using vba