| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse worksheet data by columns
I have a worksheet with data, lets say from columns A:Z.
I would like to flip this data by columns only. eg Z becomes A, Y becomes B, X becomes C etc. I'm thinking I should link it to a new sheet and adjust by formula. Can anyone help. Any other ideas also appreciated. Bruce |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse worksheet data by columns
Just sort the columns, Choose data_sort and in your options you can sort left to right rather than top to bottom which is the default. Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=560564 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse worksheet data by columns
Great, thanks Dav
"Dav" wrote: Just sort the columns, Choose data_sort and in your options you can sort left to right rather than top to bottom which is the default. Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=560564 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse worksheet data by columns
You may want to re-think this.
Dav's suggestion works fine if the data from Column A to Z is already alphabetically arranged. If not, perhaps you could try entering the numbers 1 to 26 across A to Z and sort left to right on them. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 00:08:01 -0700, Bruce wrote: Great, thanks Dav "Dav" wrote: Just sort the columns, Choose data_sort and in your options you can sort left to right rather than top to bottom which is the default. Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=560564 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| summing columns if there is data | Excel Worksheet Functions | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
