The following solution depends on there being something in cells
O1:Q1, nothing in cell R1, something in S1:U1, nothing in V1, etc.

First insert a temporary blank row at the very top of the sheet.
In cell O1 place this formula:
=IF(N2="",O26,N1)
(Note that the 26 in the formula is the line  containing the revenue
(it has temporarily moved one line down), and the O is the column  I've
assumed contains the value you want to sort on (if its P or Q, change
to suit).)

Copy this formula across (with the fill handle) as far as the last
company plus one more column (to CP1 for 20 companies).
You should now have the revenue for each company  repeated on line one
4 times.

Now to sort. Starting from O1, select the block of cells to CPx, x
being the number of rows you want to include in the sort. Now go to
Data|Sort.., click the Options button and choose 'Sort left to right',
click OK, choose 'Row 1' in the topmost field, and choose
'Descending', finally, click OK.

Now just delete the top row. QED.