Excel VBA merge many columns into one on separate rows - by gorussgo I have a large array of cells in multiple columns that need to be combined into one large column with a new row for each cell. I do NOT want to merge the contents of any cells. Read the article