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
|