Sorting an array in alphabetical order
MeropiMTL
Posted messages
2
Status
Membre
-
Raymond PENTIER Posted messages 58545 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58545 Registration date Status Contributeur Last intervention -
Hello everyone,
I created a standard table with rows representing clients and 15 columns representing purchased items. The rows are random from one time to another with different client names.
Here’s the particularity:
So the first row contains the name of a client and then the items they chose. The row below, without borders, is attributed to the same client. I continue like this, with two rows for each client separated by a border.
Question:
I would like to sort the client names in alphabetical order while also sorting the second row that is adjacent to it. So, it's as if the two rows for each client are treated as one line, essentially.
I know you can sort with "data," but how do you create that sort for blocks of two rows?
I hope that’s clear enough.
Thank you very much.
I created a standard table with rows representing clients and 15 columns representing purchased items. The rows are random from one time to another with different client names.
Here’s the particularity:
So the first row contains the name of a client and then the items they chose. The row below, without borders, is attributed to the same client. I continue like this, with two rows for each client separated by a border.
Question:
I would like to sort the client names in alphabetical order while also sorting the second row that is adjacent to it. So, it's as if the two rows for each client are treated as one line, essentially.
I know you can sort with "data," but how do you create that sort for blocks of two rows?
I hope that’s clear enough.
Thank you very much.
2 réponses
Hello
without guarantee:
the simplest seems to be to repeat the client name at the top of the empty rows and sort according to this column. In principle, the "filled" row should be placed in order before the empty row.. but I haven't tested everything
to be tested on a "lost" file
regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!
without guarantee:
the simplest seems to be to repeat the client name at the top of the empty rows and sort according to this column. In principle, the "filled" row should be placed in order before the empty row.. but I haven't tested everything
to be tested on a "lost" file
regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!
Sometimes there is something written in this cell.
I will try anyway.
Thank you for your help.