how to flip paired data in a table, so last pair appears at top o.

J

jim mcgrath

i have paired data in a columnar table. how would i flip the table, so the
last data pair appear @ the top & the first @ the bottom?
 
F

Frank Kabel

Hi
in B1 enter:
1
in B2:
2
select both cells and copy down. Now sort with column B (descending)
 
Top