Forum Discussion

Rex1028's avatar
Rex1028
Copper Contributor
Nov 19, 2019
Solved

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

3 Replies

Resources