Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

normal Interleaving multiple columns into one

More
3 days 21 hours ago #1843 by dak4482
Replied by dak4482 on topic Interleaving multiple columns into one
Well, I found the answer myself. Cant believe noone was able to answer this. The solution is to use the KUTools "Transform Range" command under the "Ranges and Cells" tab. It doesnt remove the blank cells so you still have to eliminate all the blank cells in the single column but it is still alot faster than moving all 600 columns by hand.

Dan

Please Log in or Create an account to join the conversation.

More
1 week 4 days ago #1817 by dak4482
Hi all,

Looking for a way to Interleave multiple columns of data vertically into one long column putting each columns entries in one after another so that if I have for example, 4 columns, one with 10 rows one with 20 one with 30 and one with forty I end up with a column with 100 rows of data. I actually need this for a sheet with over 200 columns and want to combine them all into one so I can alphabetize the whole list and then do various filters on it.  Does KUTOOLS have a way of doing this? Couldn't find anything in the drop-downs that could help. If not, I was wondering what is used now instead of VBA for something like this with Excel? Using individual formulas in each column would be way too much and am hoping to find a way of doing it with a KUTOOLS or a VBA type effort. Any help would be appreciated.


Dan
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun