Combine multiple columns data to single column [Excel VBA]

If you want to combine multiple columns data to a single column using excel VBA, then use below code. Below macro combines data of 10 columns and displays it in first column. Change numOfColumns variable value as per your requirement. Also see VBA macro to remove empty columns