0
Undo
Votes
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.
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 - Page :
- 1
There are no replies made for this post yet.