ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to flip paired data in a table, so last pair appears at top o. (https://www.excelbanter.com/new-users-excel/4690-how-flip-paired-data-table-so-last-pair-appears-top-o.html)

jim mcgrath

how to flip paired data in a table, so last pair appears at top o.
 
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?

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

jim mcgrath wrote:
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?





All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com