Return to Question

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Copy of sample results in link, thanks Sample data

Sample data

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Copy of sample results in link, thanks Sample data

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Sample data

Sample data

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Copy of sample results in link, thanks Sample data

Sample data

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

I have used this formula to sort the column A1 to A100 so that A

=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)

thanks to one of your posts: Advanced sorting of alphanumeric data

However, how do I get this to work across four columns of data to retain the sort order of the other columns please?

Sample data

Sample data