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)))))
- Kth Smallest Element in multiple sorted arrays
- groupingBy in Streams with CollectingAndThen method -> how to get rid of Optional then use Max on the map :)
- How to check if two indexed arrays have same values even if the order is not same?
- Create tablegroup with 4 different values ordered by other value by select in mariadb
- Django admin: how to sort by one of the custom list_display fields that has no database field
- Why is the heap in heapsort "the wrong way"?
- Sorting an array before inserting to database
- Sort 1st level keys and 2nd level keys of a 2d array
- Sort values within each row of a 2d array
- Group 2d array data by one column and then sort by another column
- Sort an array according to another array
- Move an element by key before another element by key in the context of an associative array
- How to generate a random number array and sorting this array using php?
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Sort a 2D array by multiple columns
- how can i sort 2 dimensional array based on index array in PHP?
- Why does usort() not provide a stable sort for equally compared values under PHP8?
- Custom key-sort a flat associative based on another array
- How to find K most frequent elements using java collections framework?
- Sort the first and second level of a 2d array by numeric keys in DESC order
- Sort the parent level of a 3d array by a column in the deepest subarray descending
- Sort a 2d array by its keys which relate to custom sorting values in another 2d array
- Sorting a php array of arrays by custom order
- Sort an array based on related data in a 2d array
- Sort an array by keys
- How to read the last two files in a directory by comparing filenames naturally?
- Synchronously sort an array by sorting another other array
- Firestore orderBy Timestamp DESC
- Assigning sort()'s returned value to the array variable replaces array with true