How can I sort my data while keeping paired rows together?
- by Joe Lee Frank
How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows?
For example:
Original entry
A1,1 B1,1 C1,1 D1,1
A1,2 B1,2 C1,2 D1,2
A2,1 B2,1 C2,1 D2,1
A2,2 B2,2 C2,2 D2,2
Sorted reverse order
A2,1 B2,1 C2,1 D2,1 …