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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Permutation/Combination/Pairs order unimportant. 2
How to have two tables on same line? 1
Matching pairs of Data in cell 1
Working with question-answer pairs 0
Match pairs of date in cells 0
Footer On Last Page Only Not Working 1
Grouping Names in Mail Merge 0

Top