| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 91086 | 2008-06-25 11:46:00 | Yep.....Me and my buddy Excel........Again!! | Billy T (70) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 682421 | 2008-06-25 11:46:00 | Hi Team At least this isn't one of my stuff-ups: I have downloaded a pile of instrument data into Excel and for some godforsaken reason the instrument software puts it in reverse order, last data first . I want it to read down the columns from first data captured at the top to last at the bottom and since some files have 4,000 data points x five columns, a manual change is not on the cards . Needless to say the instrument software offers no options, but I am hopeful Excel will be able to reverse column order . I've searched for a couple of hours and tried out various ideas on dummy data but nothing worked, then I did a search for an add-in program and found some promising shareware, but it took me nearly an hour to get it the hell out of my computer after it tried to take over my life! :mad: If there is a way to do it in Excel, or a free program that doesn't aspire to rule the world I'd be pleased to hear about it . Has to work with Excel 2000 and W2K though . Cheers Billy 8-{) :help: |
Billy T (70) | ||
| 682422 | 2008-06-25 12:15:00 | You should be able to sort it within Excel. One thinks that you want to keep all rows in a certain order rather than just resorting data in one column? Highlight all the spreadsheet then click data sort. |
Sweep (90) | ||
| 682423 | 2008-06-25 21:07:00 | Download it again into Word,it migh not be naughty there,then you could try a transfer. | Cicero (40) | ||
| 682424 | 2008-06-25 21:34:00 | This is possibly a long winded way, but it was the first thought that came into my head. Assuming your data is in cells A1:E4500 as an example. In F1, type =A4500 In F2, type =A4499 From there, you should be able to copy those formula down to F4500 then across to J4500. Then copy and paste as values, and replace the original contents. |
the_bogan (9949) | ||
| 682425 | 2008-06-25 22:50:00 | You should be able to sort it within Excel. One thinks that you want to keep all rows in a certain order rather than just resorting data in one column? Highlight all the spreadsheet then click data sort. Yep, Data Sort did it. I found that there were a few technicalities to observe or it wouldn't sort all of the data but they were commonsense issues. Thanks Sweep, I had a gut feeling it could be done because Irecalled sorting data eons ago but only in small doses. What fooled me was the range of programs on the net purporting to do the same thing and I figured maybe there was a hole in Excel that they needed to plug. Just another case of creeping elegance probably..... Cheers Billy 8-{) :thumbs: |
Billy T (70) | ||
| 682426 | 2008-06-25 22:56:00 | Sorry Billy, misinterpreted you. I was thinking you had data that wasn't necesarilly in a logical order that you wanted to reverse. :illogical Sometimes I read between the lines too much. Glad to hear you got it sorted. |
the_bogan (9949) | ||
| 682427 | 2008-10-31 03:50:00 | I think I need to retire while I'm still almost sane. Same type of data from same source. Off to Data>Sort I went, humming cheerfully to myself, but while it sorts the date column ok, the data columns are put in strict numerical order which kinda messes up the whole deal. Some columns have a mix of alpha, numeric, and alpha-numeric info as well, which gets thoroughly munted. I've tried doing it column by column but for the life of me I can't remember what the heck I did last time to get it right and can't even see any options to play with. I simply want to reverse the order of all data of any type presented in the column. What have I missed this time? Cheers Billy 8-{) :confused: |
Billy T (70) | ||
| 682428 | 2008-10-31 17:29:00 | Hi, to reverse sort the data it relies upon a column that contains the order which I suspect you dont have so you need to create one. 1) In a new column enter the heading SortBy next adjacent to your data *ie if your data is in columns A1:J4500 then in cell K1 enter SortBy. 2) In the next 3 rows enter 1 then 2 then 3 respectively. 3) Select the 3 rows with the numbers and drag down to row 4500. If you dont want to drag the cells down 4500 rows then alternatively do the following: 3a) Select Edit | Goto from the menu. In the Reference enter the cell range you want to select (say K2:K4500 if column K is the SortBy column - make sure you exclude the SortBy row). 3b)Select Edit | Fill | Series. The default values will be Columns, Linear, and set value of 1 which is what you want but you also need to enter what the high value is. In the example K2:K4500 (which is currently the selected cells) you want to go up to number 4499 so enter 4499 in the Stop Value box then click OK. 4) Once you have a series of sequential numbers in your new column, select any cell with data and select Data | Sort, then choose the SortBy column and the option descending. Your data is now in reverse order. regards, Graham |
Parry (5696) | ||
| 1 | |||||