need help with index function. i have a bunch of data on row A and need to split them to two rows instead but retaining their alphabetical order. as the image shows.
See Question&Answers more detail:osneed help with index function. i have a bunch of data on row A and need to split them to two rows instead but retaining their alphabetical order. as the image shows.
See Question&Answers more detail:os