Hello,
I'm trying to compile data from multiple columns into one single column. For instance I have columns
a b c d which are related and I want them to be ordered
a
b
c
d
There are 60 columns that I need to sort in this fashion where the groups of the columns are not consistent numbers. Like f and g are related and h i and j are related. All of the column lengths are the same.
I have never run a macro so I'm not exactly sure where to get started, but if I could have some help I would greatly appreciate it! I do have programming knowledge though, so if you briefly explain what the macro is doing, I'd be able to figure it out. I was just copying and pasting however after spending an hour doing this and realizing I still had 9 more data sets to go I thought I'd ask for some help! Thanks!
Configuration: Windows Vista Firefox 3.0.14