Flip columns of data

  • Thread starter Thread starter mahadevan.swamy
  • Start date Start date
M

mahadevan.swamy

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
 
Select your data, then Data/ Sort / left to right/ descending.
And if you have 0 to 32, that would be 33 columns, not 32.
 
Thanks. I can;t realize I never knew that though I am so familiar with
excel. Thanks for your help

Swamy
 
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))
 
Thanks for your help

Swamy

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))
Click to expand...
 
You're very welcome.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Thanks for your help

Swamy

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

--------------------------------------------------------------------------
Click to expand...
-
Please keep all correspondence within the NewsGroup, so all may benefit
Click to expand...
!
--------------------------------------------------------------------------
- said:
Thanks. I can;t realize I never knew that though I am so familiar with
excel. Thanks for your help
Swamy
Click to expand...

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.
Click to expand...
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
Click to expand...
Mahadevan Swamy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top