|
Flip columns of data
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 |
Flip columns of data
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 ups.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 |
Flip columns of data
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 ups.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 |
Flip columns of data
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 ups.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 |
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 |
Flip columns of data
You're very welcome.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... 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 |
| All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com