I'm working with a sheet where I need to horizontal sort (left to write) multiple rows alphabetically.
Example
Phrase Word1 Word2 Word3 mobile rewards apps rewards apps mobile
Desired Output
Phrase Word1 Word2 Word3 mobile rewards apps apps mobile reward
Mike Girvin has a Youtube video: https://www.youtube.com/watch?v=RojHISXA2gM - He gets the job done on numbers using LARGE & COLUMNS. In my case, I would need to use SMALL. However LARGE & SMALL only work on numbers and not text.
Is there another Excel formula that would give me the desired output? Keep in mind, I might need to sort at least 10 columns and a few thousand rows.
Many thanks in advance!
Bookmarks