How to reverse order of rows and columns

September 10, 2005

Hello, all,

I've made a big boo-boo in an Excel 2000 spreadsheet, and I can't figure
out how to fix it.  Can you help?

I've created a table with 28 rows and 28 columns, and I've painstakingly
typed data into many of the resulting 784 cells.  Only now do I realize
that the order of the columns is reversed, i.e., what was ABCD needs to
be DCBA.  Same with the 28 rows, which have slightly different names.

You can see the table as it is now by opening or downloading it from
http://barelybad.com/eraseme_excel_test01.xls.

As you can see, the columns run from Noland to Ridgeview, and I'd like
them to run from Ridgeview to Noland.  Again, same with the rows.

My question is how to accomplish a one-time re-ordering of the columns
and the rows while, of course, keeping the data where they belong.  Is
there a way to do this?

Thanks for any help you can offer, and the more detailed the better,
because I'm not all that familiar with Excel.

--Johnny
barelybad aattsiggnn  h o t m a i l  --dot--  c o m


0
barelybad (6)
9/11/2005 1:30:40 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
580 Views

Similar Articles

[PageSpeed] 51

Johnny,

Unhide rows 4-5

Insert a 1 in A4, and Ctrl/+drag this to A31 to number the rows.
(that is, hold CTRL and drag the + sign in the bottom right corner of
the selected A6)
Select rows 4 to 31, Data, Sort, sort descending

then - unhide columns D - AE

Insert a 1 in D1 and Ctrl/+drag to AE1 to number the columns
select columns D to AE and Data, Sort, Options (select Left ro Right),
and sort descending

Clear A1 to A31 and D1 to AE1

that should give what you seek.


Johnny Wrote: 
> September 10, 2005
> 
> Hello, all,
> 
> I've made a big boo-boo in an Excel 2000 spreadsheet, and I can't
> figure
> out how to fix it.  Can you help?
> 
> I've created a table with 28 rows and 28 columns, and I've
> painstakingly
> typed data into many of the resulting 784 cells.  Only now do I
> realize
> that the order of the columns is reversed, i.e., what was ABCD needs
> to
> be DCBA.  Same with the 28 rows, which have slightly different names.
> 
> You can see the table as it is now by opening or downloading it from
> http://barelybad.com/eraseme_excel_test01.xls.
> 
> As you can see, the columns run from Noland to Ridgeview, and I'd like
> them to run from Ridgeview to Noland.  Again, same with the rows.
> 
> My question is how to accomplish a one-time re-ordering of the columns
> and the rows while, of course, keeping the data where they belong.  Is
> there a way to do this?
> 
> Thanks for any help you can offer, and the more detailed the better,
> because I'm not all that familiar with Excel.
> 
> --Johnny
> barelybad aattsiggnn  h o t m a i l  --dot--  c o m


-- 
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=466559

0
9/11/2005 2:25:33 AM
First re-arrange the table vertically:

- Highlight column B and insert a new column. There should now be a new
column B that is blank.
- In this new column B, next to the names Noland, Crysler etc. enter the
numbers 1, 2... all the way down to 28 for Ridgeview.
- Highlight the area you want to re-organize. (Should be B4:AF31)
- Choose from the menu Data>Sort.
- Under "Sort by" choose Column B, and also click the "Descending" button.
- For "My data range has", make sure that you choose "No header row"
- Then OK.
- Delete column B that you just created since this is no longer needed.

To re-arrange the table horizontally, the process is similar. You just
insert a new row instead of a new column. When you do the sorting, choose
"Options" and then for "Orientation" choose "Sort Left to Right".


"Johnny" <barelybad@hotmail.com> wrote in message
news:7b0a0$432388da$407e5bd5$13844@EVERESTKC.NET...
> September 10, 2005
>
> Hello, all,
>
> I've made a big boo-boo in an Excel 2000 spreadsheet, and I can't figure
> out how to fix it.  Can you help?
>
> I've created a table with 28 rows and 28 columns, and I've painstakingly
> typed data into many of the resulting 784 cells.  Only now do I realize
> that the order of the columns is reversed, i.e., what was ABCD needs to
> be DCBA.  Same with the 28 rows, which have slightly different names.
>
> You can see the table as it is now by opening or downloading it from
> http://barelybad.com/eraseme_excel_test01.xls.
>
> As you can see, the columns run from Noland to Ridgeview, and I'd like
> them to run from Ridgeview to Noland.  Again, same with the rows.
>
> My question is how to accomplish a one-time re-ordering of the columns
> and the rows while, of course, keeping the data where they belong.  Is
> there a way to do this?
>
> Thanks for any help you can offer, and the more detailed the better,
> because I'm not all that familiar with Excel.
>
> --Johnny
> barelybad aattsiggnn  h o t m a i l  --dot--  c o m
>
>


0
9/11/2005 2:36:48 AM
Thanks to Bryan Hessey and Shatin, who came up with the same idea.  It
worked, and you saved me a LOT of tedious and error-prone typing.

The Internet is great because of selfless and competent people like you.

--Johnny


0
barelybad (6)
9/11/2005 2:42:57 PM
Reply:

Similar Artilces:

How to ignore hidden columns in an "Average" formula?
If an "average" formula includes multiple columns, and those columns change each month by hiding old months (at end) and adding new months (at beginning) what can be done, by macro or in formula) to ignore the hidden columns? Try this if you can use 101 in your Excel version =SUBTOTAL(101,A1:C1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DotK" <DotK@discussions.microsoft.com> wrote in message news:D6F36A22-BDE4-4836-98AE-028A616A9300@microsoft.com... > If an "average" formula includes multiple columns, and thos...

Using angled column headings and borders
I'm trying to use angled column headings and borders so I can fit many columns across the page. I've tried following an article called "Using angled text and borders in Excel", but my results aren't very good--I'm having trouble placing the angled borders and angled text properly. My borders don't bend at the same angle, I guess because the columns are different widths. Also, the angled border sometimes runs through the angled column head. Can anybody help? Thanks! Lisa H Lisa, If you angle the text (Format>Cell>Alignmnet and then use the dial to ge...

Excel: keeping rows together when ordering order of left column
in my spreadsheet I want to order the left hand column (in ascending numbers) but when I do I want the rows to move with cells too, keeping the items of data in the rows with the original items of data in the left hand cells when they move place Select the data say A1:J10 and then from menu Data>Sort> --If your data has headers then select 'My data range has' headers .. --Select 'Sortby'..and hit OK -- Jacob "Tangojon" wrote: > in my spreadsheet I want to order the left hand column (in ascending numbers) > but when I do I want...

Finding Duplicated Text within Columns
I'd be grateful if anyone could help me with the following: I have 2 columns, both contain a number of items, some the same, some not; eg: Column A: Column B: Row 1: apple pear orange apple orange Row 2: orange banana banana orange Row 3: peach banana melon grape apple orange I need to compare the columns and find which rows are NOT exactly the same and, preferably, to identify the differences. For instance, in the above example, I would ignore Row 2 as the cells contain the same items (albeit in a different order), but I w...

Dual boot in reverse
Hello, I have dual boot system: driveC --> WinXP driveD --->Vista Now, I do not need WinXP anymore. I want to have only Vista and combine C & D into one, single partition. How to do that without reinstalling Vista? Your thoughts appreciated, Claire On Sun, 17 Jan 2010 15:00:12 -0500, "Claire" <replyto@fra> wrote: >Hello, > I have dual boot system: >driveC --> WinXP >driveD --->Vista >Now, I do not need WinXP anymore. >I want to have only Vista and combine C & D into one, single partition. &...

sorting multiple columns
I have multiple addresses on a work sheet. I need to have all the same zip code # together. How do I sort them by zip code so right name and address ends up with right zip code Highlight the range you want to sort before starting it. Regards, Fred "arbe" <arbe@discussions.microsoft.com> wrote in message news:56FFD696-D31F-4A99-AE8E-941C5C18D012@microsoft.com... >I have multiple addresses on a work sheet. I need to have all the same zip > code # together. How do I sort them by zip code so right name and address > ends up with right zip code Pre-se...

Finding the row number of first row in a selected range
I'm attepting to find the row number of the first row in a user selected range. I'm looping throgh the rows to perform a comparison and can establish the total number of row using Dim Lrows as integer Lrows = Selection.Rows.Count How do I extract the row number of the first row, please. Thanks in advance msgbox selection.row Eamon Wall wrote: > > I'm attepting to find the row number of the first row in a user selected > range. > I'm looping throgh the rows to perform a comparison and can establish the > total number of row using > &...

Copying selected columns from 1 chart to another.
This was previously asked in programming but the original question was missleading the answers so: From the start: My chart has names in A7:A78, skills in D1:AA1. Using RAND() and indexing a separate vertical list of the skills I can randomly generate 4 from the list. These are placed in C160:F160 with the list of names copied to A161:A232. What I want to do is find each randomly generated skill (C160:F160) in D1:AA1 then copy the corresponding data from below it (*7:*78) into C161:C232 for the 1st skill, D161:D232 for the 2nd and so on for all 4. For example: 1st gener...

Deleting/removing unused rows in a worksheet
Excel 2007 all MS updates Is it possible to delete rows without ANY data automatically? Currently, I have a 2000+ row spreadsheet that has 250+ blank rows. Instead of doing this manually, how can the removal or deletion (squishing!) of the blank rows be done? For example, say I have a spreadsheet with data in rows 1, 2,4,6,8 and 12. All I really need are THESE rows with data. I want to squish, eliminate, delete the rows in 3,5,7,9,10,11. How can I do this by 'highlighting' or whatever the entire set (rows 1-12 above) and then performing an "delete empty row"...

Column headings switched to numbers
Bit Frustrated and know the answer is simple but can't seem to find i anywhere. I have one spreadsheet where the column headings are numbers rathe than letters and all referenced appear to be distinct to the Row an Column R1C5 etc. In some cases formulas are generated with what appear to be relative row/column numbers. I would like to get this spreadshee back to the Normal row and column headings so the functions work as know them. Any suggestions ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly fro...

Purchase Orders/Transfers
When we print a PO or an Interstore Transfer, extended costs and total of the shipment, etc. do not print on the form. Is there a way to set these up so they do print? Thanks -- Rich ...

Custom Order
Hello, I've a table like this: ID - PartNo ------------- 1 a 2 b 3 c 4 d I pass a query to access (through ASP.Net) like this: SELECT * FROM tbl Where PartNo In ('d','a','c') The result is: a c d records. but I expect this order: d a c How can I customize order query? Something like this imaginary query: Select * From tbl Where PartNo In ('d','a','c') Order By PartNo('d',;a','c')!!! Found that: SELECT * FROM tbl Where PartNo In ('d','a','c') order by PartNo='...

How do I change column (A) to say First Name?
I want to rename the column can that be done. Like I do in works. Column (A) I want to change to First Name. and then change B and so on. Can that be done in excel 2000 . Thanks. No it can't be done. Best you can do is put the heading in row 1, and suppress row and column headings (Tools>Options>View and uncheck the Row and Column headers box. -- HTH RP (remove nothere from the email address if mailing direct) "nort99" <nort99@discussions.microsoft.com> wrote in message news:958FA8BD-6A9C-4E0E-BEB0-960E0DDD9CCA@microsoft.com... > I want to rename the c...

<Enter> to go to column A?
I have a spreadsheet in which the <Enter> key causes the cursor to move one column to the right. But, when in the last column for this sheet I'd like the <Enter> key to cause the cursor to drop down one row and go to column A. I know this can be done with a macro, but can is there a way that this can be done solely with the <Enter> key? Thanks, Bill Not solely with the <enter> key but you can use the Tab key to move to the right as you enter data. When you get to last column hit <enter> key to go back to start column one row down. Note: <enter> ke...

Manufacture Order Create Date
Hi, I am looking at WO010032. There are various date fields, but none for "create date", as in when the MO was created. Does this field lie in any other tables? Thanks in advance. -- Jim Lines Sr. Microsoft Dynamics GP Applications Consultant Certified Microsoft Dynamics GP Specialist The MOP_Order_Activity table (MOP10213) contains a line for each event in the MO's life. Pull Line sequence number 1.000 (the first event) and this will be the creation date. -- Richard L. Whaley Author / Consultant / MVP 2006-2008 Documentation for Software Users Get our Free Tips and...

Open Order Errors
I get the error message "An error was encountered while attempting retrieve account credit information" every time I open an order followed by "No sales orders can be added at this time....." This has only just started happening and I have rest all my defaults in IE. I have the same access as another user who does not receive this error Help!! ...

REVERSING TEXT
HOW CAN I REVERSE TEXT AND PICTURES ON PUBLISHER TO PRINT ONTO T.SHIRTS spike <spike@discussions.microsoft.com> was very recently heard to utter: > HOW CAN I REVERSE TEXT AND PICTURES ON PUBLISHER TO PRINT ONTO > T.SHIRTS YES. PLEASE READ REPLY TO YOUR FIRST POST. Please do not talk in all caps. It is considered shouting and makes your post difficult to read and is rude. Your first message ("how do i reversie pictures and text for printing to t.shirts") is directly below this one and has been answered by yours truly. -- Ed Bennett - MVP Microsoft Publisher ...

What is an automatic way to delete all rows of a certain kind
Is there a way to do this automatically? I want to change (a) below to (b) below further (i.e. just all those rows in between the data - pretty simple) I have a lot of data, lets assume. (a) -------------- 27 4:11 5:44 1:12 5:08 8:38 10:12 28 4:12 5:45 1:12 5:08 8:38 10:12 29 4:12 5:45 1:12 5:08 8:38 10:12 30 4:13 5:46 1:12 5:08 8:38 10:12 July Date Fajr Sunrise Dhuhr Asr Maghrib Isha 1 4:13 5:46 1:13 5:09 8:38 10:12 2 4:14 5:47 1:13 5:09 8:38 10:11 3 4:15 5:47 1:13 5:09 8:38 10:11 4 4:16 5:48 1:13 5:09 8:37 10:11 5 4:16 5:48 1:13 5:09 8:37 10:10 6 4:17 5:49 1:13 5:09...

POP
Hello all, We have an issue where we have change all our POP numbers to 000000000000010000 and what I want is on the Purchase order report for only the 10000 to show up.. I have tried shrinking the the Po Number field down and it still shows the entire 000000000000010000. I beleive I also have set up the security correct but still shows the same.. TIA ...

Formulas reversed
Using Office 2007 and windows XP. The back slash has become "multiply" and the star has become "divide". In other words, these two symbols are reversed. Have no idea how this happened. How can it be reversed back to normal? thanks. Please give an example of formula, values of input cells and result of formula -- Kind regards, Niek Otten Microsoft MVP - Excel "RENEE" <RENEE@discussions.microsoft.com> wrote in message news:C56D666E-70CD-4E8F-97F9-1FAD9CE92024@microsoft.com... > Using Office 2007 and windows XP. The back slas...

update next row
I need to update a field in a table I use for grooming data. Something like... IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) ....and it would loop through all rows and stop at last row How do I accomplish that with an UPDATE query? After update, data gets exported then deleted. thanks! On Wed, 2 Dec 2009 21:47:15 -0500, "shank" <shank@tampabay.rr.com> wrote: >I need to update a field in a table I use for grooming data. > >Something like... >IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) >...and it would loop through all rows and stop at...

LOOKUP a column from another worksheet
Help please i want to show a column from a worksheet based on a TRUE/FALSE Condition . That is if the value in row2 is TRUE show the column ( im wanting to show this data on a different worksheet within the same workbook) does this make sense ?? =IF(Sheet2!B1=TRUE,Sheet2!A1,"") Put this say in sheet1 A1 It reads in cell A1 from sheet2 if the statement "TRUE" is in cell B1 of sheet2 If B1 reads "FALSE" it will stay blank ("") "UTPC01" wrote: > Help please i want to show a column from a worksheet based on a TRUE/FALS...

SOP Order Fulfillment Detail Report
This report is using Sales Serial/Lot Work and History Temp which doesn't include the Manufacturing and Expiry Dates. I tried to include the Sales Serial/Lot Work and History table but it seems that there is no option for me to do it in Report Table Relationship. Cheers, Sugih ...

SUm function and adding rows
Is there a way to get the SUM function to increase the range if a row is added right above the previous SUM range. FOr example to go from SUM(C3, C22) to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM function resides. You could use a formula like this in C23: =SUM(C2:OFFSET(C23,-1,0)) FredZack wrote: > > Is there a way to get the SUM function to increase the range if a row is > added right above the previous SUM range. FOr example to go from SUM(C3, C22) > to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM >...

Possible to reverse a row of entries?
Is there a command or format command that will let me take a row of entries and reverse them? In other words if I have rows #1 through #10 top to bottom, I now want them to go #10 to #1 top to bottom. thanks Rick Hi in B1 enter =OFFET($A$10,-(ROW()-1),0) and copy down for ten rows -- Regards Frank Kabel Frankfurt, Germany rs wrote: > Is there a command or format command that will let me take a row of > entries and reverse them? In other words if I have rows #1 through > #10 top to bottom, I now want them to go #10 to #1 top to bottom. > > thanks > > Rick Ric...