View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mahadevan.swamy@gmail.com is offline
external usenet poster
 
Posts: 59
Default Flip columns of data

Thanks for your help

Swamy

On Apr 6, 5:29 pm, "Ragdyer" wrote:
You can also use a formula, and make a *reverse copy* of your data, leaving
the original data untouched.

With data in A1 to AG1, (and that's 33 cells, not 32), enter this formula
*anywhere*, and drag across 33 columns:

=INDEX($A$1:$AG$1,33-(COLUMN(A1)-1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
wrote in message

ups.com...

Thanks. I can;t realize I never knew that though I am so familiar with
excel. Thanks for your help


Swamy


On Apr 6, 5:06 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Select your data, then Data/ Sort / left to right/ descending.
And if you have 0 to 32, that would be 33 columns, not 32.
--
David Biddulph


wrote in message


roups.com...


Hi,


I have 32 columns of data numbered from 0 -32. What I would like to do
is to flip those data starting from 32 to 0. Is there a way to do this
rather than performing some basic cut and paste? Thanks


Mahadevan Swamy