PDA

View Full Version : VBA Code for Combining Multiple Columns into One Column - Excel for Mac



mbrio
08-06-2014, 12:22 PM
Hi there,

I want a VBA code for combining multiple columns into one column in Excel.

The data I want to convert is as follows:

AA EE II
BB FF JJ
CC GG KK
DD HH LL

And I want a VBA code to convert it as follows:

AA
BB
CC
DD
EE
FF
GG
HH
II
JJ
KK
LL

Thanks so much!