Reversing rows of information

[lehigh46]

Hi All:

I have a sheet with equipment hours
Each piece of equipment has two rows. (I have over 100 pieces of
equipment)
The first row is "stand by time"
The second row is "operating time"
I have since found that the two rows for each piece of equipment are
reversed.
Is there a way "flip" the two rows on each piece?

Thanks for your help

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

 

[Guest]

You could select the second row (click on the row header, say '3'), then Edit

Cut. Then select the first row ('2') then Insert > Cut Cells. Then you'd

just want to type over the incorrect labels.

BTW, if you intend to keep this going for a while, I'd suggest you set up
each p/n in its own row (rather than its own column), as you'll run out of
available columns pretty quickly, whereas you can have a LOT of rows. To
change that around, you would select your table, then Edit > Copy, click
where the first cell of the new table should go, then Edit > Paste Special,
and select Transpose.

 

[Richard Buttrey]

Hi All:

I have a sheet with equipment hours
Each piece of equipment has two rows. (I have over 100 pieces of
equipment)
The first row is "stand by time"
The second row is "operating time"
I have since found that the two rows for each piece of equipment are
reversed.
Is there a way "flip" the two rows on each piece?

Thanks for your help

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Assuming each of your equipment rows are together, i.e. rows 2+3, 4&5,
88&89 etc. then you could use a helper column. If the Equipment number
is in column A and the time in column B, then in C2 put the following:

=IF(A2<>A1,2,1)
and copy down.

Now re-sort your data with A as the first sort and B as the Second
(ascending) sort.

HTH



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________