How can I sort my data while keeping paired rows together?
Posted
by
Joe Lee Frank
on Super User
See other posts from Super User
or by Joe Lee Frank
Published on 2014-05-29T21:18:27Z
Indexed on
2014/05/29
21:36 UTC
Read the original article
Hit count: 350
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
A2,2 B2,2 C2,2 D2,2
A1,1 B1,1 C1,1 D1,1
A1,2 B1,2 C1,2 D1,2
© Super User or respective owner
