View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
August August is offline
external usenet poster
 
Posts: 4
Default Flipping Data in Excel

I need to flip a few rows of data. For instance, right now I have
colums that look like this:

1 6
2 7
3 8
4 9
5 10

I need them to look like this:

5 10
4 9
3 8
2 7
1 6

These columns have thousands of entries in them, so if there's a
function that can cover this for me it would save me a ton of time.