Forum Discussion

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Jan 29, 2024
Solved

Need a function or combination of functions to allow me to combine (sort?) multiple arrays into one

I have multiple columns that I need to sort into one. I can not find a way to get the sort function to do this and all other methods I've tried are cumbersome.   Any help here please, thanks   Th...
Formulas and Functions
  • TheOldPuterMan's avatar
    TheOldPuterMan
    Jan 30, 2024
    I ended up using a combination of SORT, FILTER, CHOOSE and VSTACK to get what I needed. Your suggestion to look at CHOSECOL() gotme thinking.

    Thanks!! TheOldPuterMan
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jan 29, 2024
Did you try SORTBY() function. Or use CHOOSECOLS() function then apply SORT() function. Attach a sample file and show your desired output.
  • TheOldPuterMan's avatar
    TheOldPuterMan
    Brass Contributor
    Jan 30, 2024
    I ended up using a combination of SORT, FILTER, CHOOSE and VSTACK to get what I needed. Your suggestion to look at CHOSECOL() gotme thinking.

    Thanks!! TheOldPuterMan

Resources