LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Invert a column of data.

I have a sheet 24 columns by 5000 rows.
I need to invert all of the data.
Transpose turns all data 90 degree, then will turn it back to original
layout.
I can do it one cell at a time.. ie in AA1 =A5000 etc.

Is there a way to do this all at once, or even 1 column at a time?

Thanks for your help.
Mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invert a column Jakobshavn Isbrae Excel Worksheet Functions 5 June 13th 07 01:30 AM
invert Lines and column on Excel Dhfan Excel Discussion (Misc queries) 3 February 23rd 07 07:41 PM
reverse or invert column data Eggle Excel Worksheet Functions 1 October 4th 06 01:13 AM
how do you invert a column Chris Excel Discussion (Misc queries) 7 August 21st 06 11:42 PM
How do I invert a column in Excel? 3-togo Excel Discussion (Misc queries) 1 February 8th 06 03:27 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"