Sorting the string combined with arrayformula()
I have this data in Col A and the result I want in col B :
I want to create arrayformula in col B so it will take the string from col A and sort it.
if without using arrayformula() then per row I can use this formula (for example in col B1) :
=join(",",sort(tocol(split(A1,","))))
My question how to combine it with the arrayformula() to automatically apply for every value in col A. I tried this one but doesn't work :
=ARRAYFORMULA( join(",",sort(tocol(split(A1:A,",")))) )
Solution
Use MAP() or BYROW() function. Try-
=MAP(TOCOL(A:A,1),LAMBDA(r,JOIN(",",SORT(TOCOL(SPLIT(r,","),1)))))
- How to use the sorted() and min() function with OR-Tools in python?
- Why does sorting strings by length give incorrect results?
- How do I sort a multidimensional array by one of the fields of the inner array in PHP?
- Sort a 2d array by one column then another column
- Sort an array of arrays by a column value in a descending direction
- Sort array of objects by datetime values formatted as Y-n-d H:i:s
- PHP Multidimensional Array Sort array_reverse not working?
- arsort() doesn't provide a stable sort for elements with the same value
- Why does print_r(arsort($array)) output 1?
- sort() is not returning the sorted array
- How to naturally sort a flat array with arsort()?
- Copy / Paste Cell Formatting AND Sort Ascending Numerically
- Sort Dictionary by keys
- Sort an array of objects in React and render them
- Why doesn't localeCompare work as I expect?
- Sorting an array of objects by property values
- Sort `.bash_history` by timestamp
- How do I compare version numbers in Python?
- Map and Sort in one iteration in Javascript?
- How to sort first M elements in N length array?
- Naturally sort the leading and trailing parts of undelimited strings in a flat array
- How to shuffle a list in vim?
- Comparing Performance of Parallel Sorting: std::sort vs std::execution::par vs OpenMP
- Sorting unbound DataGridView column, alphanumerically in Windows Forms app
- Finding object in list by specific criteria (second greatest value)
- How to sort a string array by numeric style?
- Parse multiline text and sort array rows by time range expressions
- What algorithms do popular C++ compilers use for std::sort and std::stable_sort?
- How can I sort a vector of floats in Rust?
- How do I sort a dictionary by key?