Forum Discussion
Horizontal Sort
I wish to perform a horizontal sort on multiple rows of text data. Each row has 4 columns. Highly repetitive steps, but can't find a function that will do and can't figure how to develop a macro that performs the sort for one row then moves to the next. I wish to sort in alpha order (each name is in sep column).
C. Feeney S. Scott B. Hendren S. Newman
D. Beernink J. Staton T. Trenton
D. Dropek M. Judd B. Kauth J. Grootenhuis
D. Engelkes D. Sowerby R. Boyd G. Kletz
D. Fox D. VanOpdorp A. Veberg C. Young
D. Harris J. Harris R. Westen J. Wessels
D. McNeese D. Danner M. Donnelly P. French
Please check this post, sample is somewhere in the middle https://www.ablebits.com/office-addins-blog/2018/04/11/alphabetize-excel-sort-columns-rows/
Another solution could be with Power Query if you consider it.
3 Replies
- SergeiBaklanDiamond Contributor
Please check this post, sample is somewhere in the middle https://www.ablebits.com/office-addins-blog/2018/04/11/alphabetize-excel-sort-columns-rows/
Another solution could be with Power Query if you consider it.
- Rex1028Copper Contributor
- SergeiBaklanDiamond Contributor
Rex1028 , you are welcome