Search : in
By :

Copying multiple columns into one long column

sumgrl73, on Oct 27, 2009 1:55:30 am GMT 
 Report this message to moderators

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

Best answers for « Copying multiple columns into one long column » in :
Assembling multiple PDF files Show Assembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
Renaming multiple files in batch ShowRenaming multiple files in batch Native features Using a third-party program Renaming a large number of files can quickly become tedious. Fortunately, there are tools to automate this task in many cases: Native features On Windows...
Expand your Desktop over multiple monitors ShowExpand your Desktop over multiple monitors Hardware Requirements Software Requirements How to proceed If you are using Windows and want to enlarge your current desktop without having to buy another huge screen, this is possible by...
Converting your PDF file into an Image ShowConverting your PDF file into an Image Universal Document Converter PDF2IMAGE PDF TO IMAGE CONVERTER You could have encountered difficulties to modify PDF docs in the past. Nowadays this is no more trouble as there are several PDF...
Download Magic ISO ShowMagicISO is a creation/edition/extraction software of ISO images supporting a large number of ISO image format. It allows to create ISO images. It is also capable of converting ISO images into BIN format and vice versa. In addition, it allows to...
Types of networks ShowWide Area Network (WAN) A WAN (Wide Area Network) connects multiple LANs to one another over great geographic distances, the size of a country or continent. The speed available on a WAN varies depending on the cost of the connections (which...