Multiple columns into a single column

Jags - Updated on Jun 17, 2018 at 04:46 AM

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